DBCC CHECKDB WITH repair_allow_data_loss
before runing DBCC CHECKDB WITH repair_allow_data_loss, How can i know what table and data that will be deleted
Software/Hardware used:
Software/Hardware used:
ASKED:
October 28, 2004 6:57 AM
UPDATED:
November 10, 2010 9:18 AM
Answer Wiki:
U can use the following :
In SSMS u can try right-clicking on the dB and navigating through Reports > Standard Reports > Schema Changes History. From here u can know deleted tables names !
If u know the table name before running try this syntax :
DBCC CHECKTABLE
(
table_name | view_name
[ , { NOINDEX | index_id }
|, { REPAIR_ALLOW_DATA_LOSS | REPAIR_FAST | REPAIR_REBUILD }
]
)
[ WITH
{ ALL_ERRORMSGS ]
[ , EXTENDED_LOGICAL_CHECKS ]
[ , NO_INFOMSGS ]
[ , TABLOCK ]
[ , ESTIMATEONLY ]
[ , { PHYSICAL_ONLY | DATA_PURITY } ]
}
]
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
