June 4, 2009 at 1:38 am
What should I do if one of my table is corrupted..?
(in case if DBCC Checktabke returns error.)
Thanks,
June 4, 2009 at 1:59 am
It depends. If the error happened on a none clustered index, then you can just drop the index and recreate it. If the error is on the clustered index or a heap then you can run dbcc checkDB with one of the repair options. Notice that you'll might have to use the REPAIR_ALLOW_DATA_LOSE which can cause data lose. You can also restore the database from your backup file. If the error is on one of the system tables then you'll might have one choice only – restore the database from a backup.
In any case it is recommended that after fixing your problem you should run DBCC checkDB again to make sure that you don't have any more problems. I would also ask the administrators group to check the disks/storage that is used by this server.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 4, 2009 at 2:30 am
Take a look at this article. http://www.sqlservercentral.com/articles/65804/
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
June 5, 2009 at 8:43 am
search the web to find Paul Randall's blogs about dbcc checkdb. He litterally worked on that code in the engine at Microsoft. I also recommend you hire a professional to help guide you with this issue, or perhaps open a ticket with Microsoft support.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply