Unable to backup my SQL server database with Error Number=8921, Message=Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent.

Question

Hi,

I am not able to backup one of the Database(212GB) with dbcc checkdb, giving error : when check database error. Unknown Sql Exception (Number=8921, Message=Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.) when we trying to backup from SQL Management Studio 2012.

I have try to backup from

1. Stopped SQL services direct Copy Data File - " The request could not be performed because of an I/O error. "
2. Windows Server Backup - " The request could not be performed because of an I/O error. "

Have run chkdsk no errors.

Checked the SQL server log file giving messages :
A read of the file 'C:\XXX\AED_DATABASE_Data.mdf:MSSQL_DBCC34' at offset 0x000006e8974000 succeeded after failing 1 time(s) with error: 1117(The request could not be performed because of an I/O device error.). Additional messages in the SQL Server error log and system event log may provide more detail. This error condition threatens database integrity and must be corrected. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.

Would like to seek your advice on what are the possible steps that I might take to perform in order to rescue our database? We are planning to upgrade server spec and need this backup urgently.

Appreciated in advanced for any advises/suggestions.

Thanks and Regards.

Answer 1

Hi

DBCC CHECKDB makes extensive use of tempdb. It relies on a mechanism similar to snapshot isolation to make sure it always sees a transactionally consistent image of the database, independent what else might be going on.

Answer 2

Looks like your I/O subsystem is in really bad shape. I don't have any advice to give, nor would like to give any in a serious situation like this. I think you need to get a professional on board from the hardware vendor, and possibly also Microsoft to help you.

Answer 3

Hi @LisaQ ,

Welcome to Microsoft Q&A!
Firstly, are you able to restart SQL Server? If there is a problem with the TempDB database, a restart should clear this since it recreates the TempDB files. Of course you are experiencing a lot of I/O problems with the reported errors, it seems that your hardware is besides the problem. You can try to run some hardware diagnostics program.
You can get some ideas from this link: [The Request Could Not Be Performed Because of an I/O Device Error Solved. I also agree that you need to contact the hardware vendor.

Best regards,
Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.