SQL Backup fail with error "Final error: 0xe0008443 - One or more SQL Database consistency checks have failed"

Article:TECH144229  |  Created: 2010-11-15  |  Updated: 2012-05-17  |  Article URL http://www.symantec.com/docs/TECH144229
Article Type
Technical Solution


Issue



SQL Backup fail with error "Final error: 0xe0008443 - One or more SQL Database consistency checks have failed"


Error



Final error: 0xe0008443 - One or more SQL Database consistency checks have failed.
Final error category: Resource Errors
For additional information regarding this error refer to link V-79-57344-33859 

Errors :
Backup- Server Name V-79-57344-65085 - There was a problem running the DBCC.
Database 'Database Name' cannot be opened due to inaccessible files or insufficient memory or disk space.  See the SQL Server errorlog for details.


Cause



- This error is seen if the Database being backed up is not online or cannot be accessed.

- This error is also seen if there is a consistency issue with actual database. It can be checked by using 'dbcc checkdb( database name ) command for respective database.


Solution



1. Verify that the database in question is online, if the database is not online it will need to be online for backups.
2. If the database is online, verify the database can be accessed. 

 


Supplemental Materials

SourceUMI
ValueV-79-57344-65085
Description

There was a problem running the DBCC


SourceError Code
Value0xe0008443
Description

One or more SQL Database consistency checks have failed




Article URL http://www.symantec.com/docs/TECH144229


Terms of use for this information are found in Legal Notices