troubleshooting Question

Pitfalls to Running DBCC CHECKDB on a database server that has not been done in 1000+ days

Avatar of mike1142
mike1142 asked on
Microsoft SQL Server 2008
12 Comments1 Solution178 ViewsLast Modified:
I have a database that I have run every optimization on I can think of. We have tuned the server to the best we are going to get and I have tuned the queries as well and response times are reasonable.

The only thing left to do is to get caught up on maintenance. CHECKDB has not been run in over 1000 days. I actually do not think it has ever been run. I am afraid to do it because of what it might find. If the data is corrupt the backups will be corrupt. There is potential loss of data if fixes are needed and certainly some work if anything else is found.

They were on RTM and I had them patch to SP 3 does this help?

What are the issues I could face? Would anyone advise a course of action? PHYSICAL_ONLY at first? NOINDEX? I just created about the only ones that are there.

Thoughts?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 12 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 12 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros