Hello all and thanks for your time.
I just added th Check Database Integrity Task to my daily maintenance plan yesterday, and this morning I got an alert from SQL:
Microsoft(R) Server Maintenance Utility (Unicode) Version 10.0.5512 Report was generated on "myServer\myInstance".
Maintenance Plan: 7 Day Retention Full Backups
Status: Warning: One or more tasks failed.
Check Database Integrity Task (myServer\myInstance) Check Database integrity on Local server connection Databases that have a compatibility level of 70 (SQL Server version 7.0) will be skipped.
Databases: All databases
Task start: 2014-03-14T01:00:01.
Task end: 2014-03-14T01:00:11.
Failed: (-1073548784) Executing the query "DBCC CHECKDB(N'myDatabase') WITH NO_INFOMSGS " failed with the following error: "Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
If i run the tsql manually, with no_infomsgs, i get:
Msg 8921, Level 16, State 1, Line 1
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.
I checked TempDB, 35.13MB size with 30.98MB available, seems ok.
When I viewed the msdb.suspect_pages table, I found an entry:
database_id file_id page_id event_type error_count last_update_date
8 1 458 2 7 2014-03-14 08:54:56.457
I would have just restored from backup, but since I just added this task to the maint plan, I fear it's been going on for awhile. I don't see any issues in production, just this message.
I'm wondering A. is something wrong? B. What is wrong? C. Can I fix it without a backup?
Thanks again for your input.