Sql 2008 R2 single table corrupted

[felixwiener]

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.

[xendrome]

You're going to have to run the command

 

ALTER DATABASE DBNAMEHERE SET SINGLE_USER
DBCC CHECKTABLE('TABLENAMEHERE',REPAIR_REBUILD)

 

SQL is transactional, so it should roll back logs till the problem is fixed. You need to have a good backup at some point.