Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

How disable DBCC CHEKCDB command Expand / Collapse
Author
Message
Posted Thursday, November 07, 2013 8:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 1:40 PM
Points: 3, Visits: 294
Hi,

I had the same issue, all my error log was with the message:

starting up databases xxx checkdb for database xxx finished without errors

Below forum has helped me:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/61492307-1849-4a07-ad80-0499a5e5425f/checkdb-running-constatly?forum=sqldatabaseengine

Just set the database options of Auto_Close to false.

Cheers...!!
Post #1512318
Posted Friday, November 08, 2013 2:40 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 8:46 AM
Points: 845, Visits: 2,331
GilaMonster (8/28/2012)
eric.lyons (8/28/2012)


Old databases -- has no activity


Doesn't mean they can't be corrupted due to an IO subsystem glitch. It you absolutely don't care about them at all, fine. If you use them at all, they should still get consistency checks every now and again.


I'd have to agree, and say that I would either schedule regular CHECKDB runs, or drop the databases entirely. If the data doesn't matter, then drop it. If you can't drop it, then it does matter, and you should run CHECKDB regularly to spot errors.

And yes, I've seen one system where a hard drive had failed silently, and no errors appeared. Then another drive failed catastrophically, and all the errors came to light (RAID5) as actually corrupt data.
Post #1512819
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse