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:
 

  • SQL 2005 backups fail on specific databases with error "The backup of full-text catalog 'FullTextCatalog' is not permitted because it is not online."

http://www.veritas.com/docs/000035290

  •  Backup of full-text catalog not permitted because it not online occurs during a full backup of SQL 2005 Databases

http://www.veritas.com/docs/000035877

 

  •   Backup of SQL database fails with error "It is acting as a mirror database."

http://www.veritas.com/docs/000090969

  •   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".

http://www.veritas.com/docs/000036536

  • 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

  • After applying Hot fix 38 for Backup Exec 11d or upgrading to Backup Exec 12, differential backups fail when using the SQL Agent to backup the Backup Exec Database (BEDB)

  • 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.

http://www.veritas.com/docs/000037915

 
  •  "An error occurred on a query to database <databasename>. Cannot apply the backup on device '<database GUID>' to database '<databasename>'. "  occurs during an SQL Differential Restore

https://www.veritas.com/support/en_US/article.000028946

  • "Database Query Failure. See the job log for details" (a0008492 HEX or e0008492 HEX) is reported during a restore of a SQL database

http://www.veritas.com/docs/000026221

 

 

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)