-
Title
Maintenance Plan 'Check Database Integrity Task' only runs against 'master' -
Description
LiteSpeed maintenance plans on SQL 2005 servers with the integrity check tasks. The maintenance plans are set to check and backup "all databases". My issue is that it appears that the 'Check Database Integrity Task' only runs against 'master' in my maintenance plans since the application of SP2.
DBCC CHECKDB (mssqlsystemresource) WITH no_infomsgs executed by username found 0 errors and repaired 0 errors. Elapsed time: 0 hours 0 minutes 0 seconds.
DBCC CHECKDB (master) WITH no_infomsgs executed by usernam found 0 errors and repaired 0 errors. Elapsed time: 0 hours 0 minutes 1 seconds.
Rather than seeing one of these messages for each database on the server, there are multiple sets for master and mssqlsystemresource. -
Cause
Microsoft SQL Server 2005 SP2 software defect.
-
Resolution
WORKAROUND:
This is not a LiteSpeed error, it is the result of the Service Pack on the SQL Server.
Please review the suggestions at:
http://blogs.msdn.com/psssql/archive/2007/04/06/post-sql-server-2005-service-pack-2-sp2-fixes-explained.aspx
http://support.microsoft.com/?kbid=934458