October 15, 2009 at 6:51 pm
Hey guys...new here 1st post. I wanted to know if I run a dbcc checkdb and I find corruption, what is the best way (steps if you would be so kind) to remove the corruption?
October 16, 2009 at 1:01 am
bcp is only necessary when you have irreparable corruption and no clean backups. The best way to recover from corruption (depending on the severity) is to restore a clean backup.
Take a look at this article. http://www.sqlservercentral.com/articles/65804/, if you have any questions afterwards, please ask.
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
October 26, 2009 at 11:30 pm
A good backup strategy and regular checking of the database's health (dbcc checkdb) is the best way to handle this.
"Keep Trying"
October 31, 2009 at 1:19 am
basicly after you DBCC the database and if there are erros found, u gonna find the minimum repair level (u gonna find it on the third line from the bottom) if its repair_rebuild then no data loss and if its repair_allow_data_loss then u better restore the missing record from previous (error free) backup :hehe:
March 18, 2011 at 4:22 am
If after checking the mysql database, you found that it is corrupted then you must go for mysql repair tool that is especially meant to resolve all teh corruption issues existing in the database in least amount of time period and thus can be served as the best possible option to remove corruption.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply