In a SQL Server 2008 instanece, I'm running a maintenance plan that does a DBCC CHECKDB (<myDB>) WITH NO_INFOMSGS. It ran successfully on all databases but the last one. It is now suspended for hours on the DBCC CHECKDB command (PAGEIOLATCH_EX wait) on the last database in the plan.
WHy is the DBCC CHECKDB suspended? HOw can I stop the check? Will that "break" anything? What does this mean when dbcc is in a SUSPENDED status? How can I can I keep this from happening again?
I do have a full backup of the database. But I hope I don't have to use.
I had done a full backup of the databse and its transaction log, then kicked of the checkdb.
After the t-log backup completed, I shrunk the log file with this command:
DBCC SHRINKFILE (N'MniServiceBroker_LOG' , 0, TRUNCATEONLY)