July 15, 2004 at 11:57 am
I know you need to run this at off-peak hours. For those of you who are DBA's how often do you run the command against the Database, daily or once weekly. Looking for suggestions.
Thanks
Bunmi
July 15, 2004 at 12:00 pm
If possible, I would run it on daily basis before the backup.
July 16, 2004 at 7:06 am
It depends on your environment and how long it will take to run. If you can run a full DBCC every night on all your DB's then go for it. if not due to time constraints, you can schedule it along with your index defrags, etc.. (other DBBC commands) as a weekly Job to run on the weekend or do a couple of DB's a night.
Adam Jorgensen
Principal Architect
Top Gun Performance
jorgensen.adam@gmail.com
“Tuning Is Not Just For Guitars...”
July 16, 2004 at 8:17 am
I very, very rarely had anything every come up in checkdb, so I tend to run is weekly. That being said, if you can, as Alan mentioned, nightly before backups is better.
July 16, 2004 at 2:00 pm
For version 6.5 or earlier definitely run it daily before backups. For versions 7.0 and 2000 weekly is within best practices prescribed by most any of the 'experts'.
My personal experience is that I have never had a 7.0 or 2000 DB fail a DBCC, but have had a handfull of 6.5 corruptions.
Bob McEuen
July 25, 2004 at 11:37 pm
I run my DBCC CheckDb's with my Index Defrags over the weekend. Since our databases are quite large and it would throw out our backup window if I ran them each evening. Only very occasionaly have I had any database corruptions that were reported by running this.
Cheers,
Angela
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply