Home Forums SQL Server 2005 SQL Server 2005 Strategies How disable DBCC CHEKCDB command RE: How disable DBCC CHEKCDB command
rao2506
Valued Member
Points: 59
More actions
November 7, 2013 at 8:38 am
#1664814
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...!!