The Database ID 5, Page (1:9248), slot 0 for LOB data type node does not exist. This is usually caused by transactions that can read uncommitted data on a data page. Run DBCC CHECKTABLE
I am having above error on sql 2008 R2 , i have identified the table which is giving this error, this table doesnt allow me to query anything and repair_fast and repair_rebuild .
I am afraid to do repair_allow_data_loss.Please advise any best method to do this.
I do not have a good backup.