January 12, 2015 at 10:38 pm
how can we find the amount of data loss when we ran repair database with allow data loss ?
January 13, 2015 at 4:15 am
You really can't. You're telling the engine to do anything it has to in order to remove the corruption within the structures. That will result in, at minimum, the loss of a page worth of data (8k), but could result in as much as the entire database. You just don't know.
If the database is restorable, some corrupt databases are, you could test it on a restored system to see what will happen.
This is why using repair_allow_data_loss is the very last thing you attempt. It's also why the strongest recommendation for recovery in these situations is to have good backups in place in order to recover in that fashion.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 18, 2015 at 10:45 pm
This was removed by the editor as SPAM
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply