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 |
Problem
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.
|
|
| Source | UMI |
| Value | V-79-57344-65085 |
| Description | There was a problem running the DBCC |
| Source | Error Code |
| Value | 0xe0008443 |
| 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
Thank you.