Today, when I tried to restore the SQL database it gives an error 8967. First time I got this error message “SQL Server Database Error 8967”. I have found this problem on lots of SQL blogs and got the solution. But after using this code still, the problem persists.
RESTORE DATABASE [db_name] FROM DISK = N’C:\Backup\db1.bak’
WITH CONTINUE_AFTER_ERROR;
After running this code I got the following error:
Msg 8967, Level 16, State 216, Server SaleServer, Line 2
An internal error occurred in DBCC which prevented further processing. Please contact Customer Support.
DBCC results for ‘marketingdb ‘.
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.
To fix this error I have found few sources, please suggest which one is helpful.
https://helloacm.com/how-to-restore-sql-database-backup-by-using-sql-server-management-studio/
https://www.stellarinfo.com/sql-recovery.php
https://dzone.com/articles/how-to-repair-corrupted-sql-server-database
Please suggest which one is useful to fix my problem.
