Hi all, Just wanted to know whether, DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS , will show how much of data we lost, in case any is lost. Or will it ever show, that data is lost.
I have got about 5 million rows and this database is new to me.. and in case if any data is lost during the repair it would be difficult for me to analyze manually.
Can anybody suggest the best way to analyze the data lost. My count(*) on the corrupted table is not working, so even if data loss after REPAIR_ALLOW_DATA_LOSS i wont be able to analyze how much of data is lost.
Thanks, BA Posts