I am using SQL Server 2008 and have a Maintenance Plan setup that does a
DBCHECK before the nightly backup.
This has been working fine for months. It has started failing. If I run a
DBCHECK on the Databases, they are pass fine. I even went into the maintenance plan and clicked 'View SQL' to get the TSQL that is run during the Plan and it again all passed:
USE [ClientPortal] GO DBCC CHECKDB(N'ClientPortal') WITH NO_INFOMSGS GO USE [PHJ_Common_Objects] GO DBCC CHECKDB(N'PHJ_Common_Objects') WITH NO_INFOMSGS GO USE [PilotWebApp] GO DBCC CHECKDB(N'PilotWebApp') WITH NO_INFOMSGSenter code here
Why would this fail during the plan but work fine when run manually?