Received a call this morning that the database maintenance plan on a server is failing on it's Check Database Integrity task with the above error. From the Maintenance Plan history, it appears this began happening on 10/9/2012 and has been happening consistently with every run of DBCC CHECKDB via the plan. So far, the customer can't recall changing anything around that time.
I have suggested updating to SP4 (currently on SP3, no CUs installed). I am also currently running DBCC CheckDB ('MyDatabase') WITH No_INFOMSGS, ALL_ERRORMSGS. When that completes I'll post the results here.
Just wondering if anyone had any further suggestions of what to try or what might be wrong? I did find some other posts on the topic but none related to this particular set of circumstances. They were on older service packs or the error was produced during some other operation. Any help would be greatly appreciated.
Here is the full error message from the Maintenance Plan history:
Executing the query "DBCC CHECKDB WITH NO_INFOMSGS" failed with the following error: "Unable to deallocate a kept page.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
EDIT: Just as I finished typing that up DBCC CheckDB ('MyDatabase') WITH No_INFOMSGS, ALL_ERRORMSGS finished. The only output in the messages tab was: Command(s) completed successfully.
Any thoughts on this besides installing Service Pack 4?