August 18, 2010 at 6:19 am
Hi,
When i run the query DBCC CHECKDB onto 'msdb' the following error ocuurs.
Msg 8967, Level 16, State 216, Line 1
An internal error occurred in DBCC that prevented further processing. Contact Customer Support Services.
DBCC results for 'msdb'.
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.
CHECKDB found 0 allocation errors and 0 consistency errors in database 'msdb'.
could any one help in sorting .
Thanks in advance.
Regards
Ravi
August 18, 2010 at 7:38 am
Hi Ravi,
Sounds familiar: http://www.sqlskills.com/BLOGS/PAUL/post/CHECKDB-bug-that-people-are-hitting-Msg-8967-Level-16-State-216.aspx
From Paul's article, state 216 means that checkdb runs through a page that has a higher LSN value than the LSN of the inital snapshot. Try to run DBCC CHECKDB(msdb) WITH TABLOCK so the snapshot is not needed. Could be safe to shut down the SQL Agent before runnning the checkdb against msdb.
David B.
David B.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply