We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

REPAIRING A corrupt sql database

Medium Priority
462 Views
Last Modified: 2012-05-06
Hi Folks,

I was just looking at the documentation for dbcc checkdb and I took notice of the REPAIR OPTIONS. It recommends that to repair errors you should restore from backup. To my way of thinking that would defeat the purpose of running the command anyway. If the db was corrupt wouldn't restoring from a good backup fix all your problems anyway? Is there any good doco on this?

Kind Regards

Comment
Watch Question

Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:

Author

Commented:
Sorry .... question was a bit vague.

Microsoft recommends restoring from backup rather than dbcc checkdb
http://msdn.microsoft.com/en-us/library/ms176064.aspx

why is that?
SQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019
Commented:
Yes.. Even I suggest you to go for Backup if your Backup file is not corrupt. As your Backup file is corrupt, I have suggested that option because using dbcc checkdb, you can fix those errors (either by losing some records or by skipping the error records).

Restoring through DBCC has the following demerits (explained in more detail in the link which you provided)

DBCC CHECKDB does not examine disabled indexes
executing DBCC CHECKDB clears the plan cache for the instance of SQL Server.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
thanks - I didn't know that it clears the plan cache as well - that helped me with another issue I am having - you should get double points :)
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.