SQL backups fail with 0xe0008492 - Database Query Failure.

Article:TECH68967  |  Created: 2009-01-20  |  Updated: 2012-01-25  |  Article URL http://www.symantec.com/docs/TECH68967
Article Type
Technical Solution


Issue



SQL backups fail with 0xe0008492 - Database Query Failure.


Error



0xe0008492 - Database Query Failure.

V-79-65323-945 - Database 'BEDB' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server error log for details.


Cause



This can be caused by an abandoned  Backup Exec Database (BEDB) on a SQL instance of the target server. The database may have been left in a bad state from an incomplete uninstall from a previous Backup Exec version/installation.

 


Solution



1. In Backup Exec, remove the old BEDB selection from the backup job.
 
2. In SQL, detach and remove the old BEDB from the appropriate SQL instance.
 
 

Supplemental Materials

SourceUMI
ValueV-79-65323-945
Description

An error occurred on a query to database BEDB.


SourceError Code
Value0xe0008492
Description

Database Query Failure.



Legacy ID



321353


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


Terms of use for this information are found in Legal Notices