September 17, 2012 at 11:30 am
Could I go with repairing just the tables? Either checktable repair_allow_data_loss or checktable repair_rebuild?
September 17, 2012 at 11:36 am
No, because you have corruption not associated with any table.
Repair rebuild will do nothing. The minimum level to repair that is repair_allow_data_loss. Use a level less than that and it won't repair the damage.
I would also go with restore. It'll leave your database transactionally consistent, which repair may not do.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 17, 2012 at 11:57 pm
jdbrown239 (9/17/2012)
Could I go with repairing just the tables? Either checktable repair_allow_data_loss or checktable repair_rebuild?
Just in case you didnt see my previous answers here it is again
"restore the database from a known good backup" 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 31 through 32 (of 32 total)
You must be logged in to reply to this topic. Login to reply