November 7, 2007 at 9:00 am
We are running a SQL Server 2005 database scheduled maintenance plan with a daily nightly full backup, reorg indexes and CHECKDB. The CHECKDB step is failing with the following error.
Executing the query "DBCC CHECKDB WITH NO_INFOMSGS
" failed with the following error: “An internal error occurred in DBCC that prevented further processing. Contact Customer Support Services.
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.
Do we need to increase tempdb space?
Thanks,
Bob
November 7, 2007 at 9:37 am
Everytime I see a problem like this (we are using a maintenance plan and get this error) I add it to my list of why I never use maintenance plans.
You may require a fix. See http://support.microsoft.com/kb/934459
Francis
November 7, 2007 at 6:30 pm
Does tempdb autogrow?
Is there disk space?
Have you rebooted?
November 8, 2007 at 1:26 pm
Tempdb is set for auto growth.
We have enough disk space to grow if it needs to.
No. We did not reboot the database or Server in a while.
Thanks,
Bob
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply