Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 msdb Errors

Author  Topic 

Tarek
Starting Member

2 Posts

Posted - 2012-09-04 : 12:00:36
[code]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'.[/code]

Can anyone please leave a feed back !

chadmat
The Chadinator

1974 Posts

Posted - 2012-09-04 : 13:18:35
This is usually caused by an IO problem. Best course of action is going to be to restore from backup. If that is not possible, check your error log for 824 errors, that should help narrow down the problem. Also, look at Select * from msdb..suspect_pages, if you are in Full recovery, and the problem is a suspect page, you could do a page level restore.


-Chad
Go to Top of Page

prett
Posting Yak Master

212 Posts

Posted - 2012-09-05 : 04:25:45
Please check this link to solve the issue: http://www.sqlskills.com/BLOGS/PAUL/post/CHECKDB-bug-that-people-are-hitting-Msg-8967-Level-16-State-216.aspx
Go to Top of Page
   

- Advertisement -