DBCC CHECKDB execution....

Question

DBCC CHECKDB execution....

bandarimohan 57273

SSC Enthusiast

Points: 196
More actions
May 6, 2012 at 9:05 am

#268386

Hi,
In which case , we can use DBCC CHECKDB in production/testing/dev environment.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

You absolutely MUST run CheckDB on all databases on a regular basis. If you don't, how will you know if the database gets corrupt?

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Dave Brooking Ten Centuries Points: 1373 More actions · Answer 2

I don't really understand the question, but you can use it in any environment.

Dave

bandarimohan 57273 SSC Enthusiast Points: 196 More actions · Answer 3

Yes I can run any environment but in which point of time/case i can execute this DBCC CHECKDB?

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

See my first reply...

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Dave Brooking Ten Centuries Points: 1373 More actions · Answer 5

I run DBCC CHECKDB on a daily basis. The datadases I'm responsible for aren't big and we have a large maintenace window.

Dave

Dave Brooking Ten Centuries Points: 1373 More actions · Answer 6

What is preventing you from running this (DBCC CHECKDB)?

Is it you have no maintenace window, or something else?

Dave

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 7

Read this http://msdn.microsoft.com/en-us/library/ms176064%28v=sql.90%29.aspx

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Grant Fritchey SSC Guru Points: 398694 More actions · Answer 8

You can run it on any environment. As you've already been told by Gail, you must run it in Production. When? Find the time when you have the least load on the system. I'd run it as often as you can up to once a day.

It brings up another question though, what's your backup schedule look like?

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning