How to troubleshoot An error occurred on a query to database" or "Database Query Failure errors that occur during a backup or restore.

Article:TECH72460  |  Created: 2010-01-18  |  Updated: 2014-01-14  |  Article URL http://www.symantec.com/docs/TECH72460
Article Type
Technical Solution


Issue



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



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.symantec.com/docs/TECH63566

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

 http://www.symantec.com/docs/TECH64785

 

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

 http://www.symantec.com/docs/TECH67641

  •   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.symantec.com/docs/TECH58674

  •  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.symantec.com/docs/TECH66220

  • SQL backup fails with "Cannot open backup device 'DBNAME'. Operating system error 0x80070002 (The system cannot find the file specified.)"

 http://www.symantec.com/docs/TECH64648
 

  • 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 while Backing up Microsoft Office SharePoint Server (MOSS) 2007.

 http://www.symantec.com/docs/TECH64494 

  • 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.symantec.com/docs/TECH35815 



SQL/SharePoint Restore:
 

  •  SQL redirect restore job fails if destination machine path is selected thru the browse button.

 http://www.symantec.com/docs/TECH69212

  • The Restore of a SQL 2005 database which has full text indexing enabled fails.

  • Restore of SQL 2005 database fails with the error message "The tail of the log for the database "TEST1" has not been backed up. Use BACKUP LOG WITH NORECOVERY to backup the log if it contains work you do not want to lose. Use the WITH REPLACE or WITH STOPAT clause of the RESTORE statement to just overwrite the contents of the log."
  • "Exclusive access could not be obtained because the database is in use" when performing a Microsoft SQL 2000 or SQL 2005 restore operation

 http://www.symantec.com/docs/TECH16063
 

  • Restore of Microsoft x64 SQL2005 Master database fails with the error "An error occurred on a query to database master" if the option "Automate master database restore" is selected.

  • When trying to restore a Microsoft SQL 2000 database to a Microsoft SQL 7 server, the Microsoft SQL restores fail with the error: "The backed-up database has on-disk structure version 539. The server supports version 515 and cannot restore or upgrade this database." 

http://www.symantec.com/docs/TECH44708

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

 http://www.symantec.com/docs/TECH37653

  • "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.symantec.com/docs/TECH28134
 


Supplemental Materials

SourceUMI
ValueV-79-57344-33938
Description

Backup or restore operation terminated abnormally. An error occurred on a query to database.


SourceError Code
Value0xe0008492
Description

Database Query Failure. See job log for details



Legacy ID



327913


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


Terms of use for this information are found in Legal Notices