How to troubleshoot An error occurred on a query to database" or "Database Query Failure errors that occur during a backup or restore.
Problem
How to troubleshoot the error : " An error occurred on a query to database or Database Query Failure errors that occur during a backup or restore."
Error Message
Final Error : " V-79-57344-33938 - Backup or restore operation terminated abnormally. An error occurred on a query to database."
" 0xe0008492 - Database Query Failure. See the job log for details."
Solution
SQL/SharePoint Backup:
Backup of full-text catalog not permitted because it not online occurs during a full backup of SQL 2005 Databases
Backup of SQL database fails with error "It is acting as a mirror database."
Differential/Log backup of SQL database fails with the error "The Backup Exec SQL Agent was not used to create the last full backup of this database. You must use the SQL Agent to run a full backup before you run a differential backup or transaction log backup"
http://www.veritas.com/docs/000090969
SQL database backups fail with error "The transaction log for database 'Databasename' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases".
SQL backup fails with "Cannot open backup device 'DBNAME'. Operating system error 0x80070002 (The system cannot find the file specified.)"
http://www.veritas.com/docs/000035812
The error "Database Query Failure. See the job log for details" (e0008492 HEX or a0008492 HEX) is reported when backing up a Microsoft SQL database
http://www.veritas.com/docs/000028317
SQL/SharePoint Restore:
SQL redirect restore job fails if destination machine path is selected thru the browse button.
Related Knowledge Base Articles
Was this content helpful?
Translated Content
Please note that this document is a translation from English, and may have been machine-translated. It is possible that updates have been made to the original version after this document was translated and published. Veritas does not guarantee the accuracy regarding the completeness of the translation. You may also refer to the English Version of this knowledge base article for up-to-date information.