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."
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."
SQL 2005 backups fail on specific databases with error "The backup of full-text catalog 'FullTextCatalog' is not permitted because it is not online."
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"
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.)"
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
SQL redirect restore job fails if destination machine path is selected thru the browse button.
"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
"Database Query Failure. See the job log for details" (a0008492 HEX or e0008492 HEX) is reported during a restore of a SQL database