Backup or restore of SQL 2005 fails with the following error in the job log "an error occurred on a query to database".

Article:TECH128896  |  Created: 2010-01-16  |  Updated: 2013-04-05  |  Article URL http://www.symantec.com/docs/TECH128896
Article Type
Technical Solution


Issue



Backup or restore of SQL 2005 fails with the following error in the job log:

 


Error



Final error: 0xe0008492 - Database Query Failure. See the job log for details.
Final error category: Resource Errors
 

For additional information regarding this error refer to link V-79-57344-33938.

V-79-65323-3202 - An error occurred on a query to database <database name>.
V-79-65323-3202 - Write on "<database name>_00__009958db_2fbb_4612_94ad_dee104571ad9_" failed: 995(error not found)
 
Backup <server name> V-79-65323-3271 - An error occurred on a query to database msdb.
V-79-65323-3271 - A nonrecoverable I/O error occurred on file "msdb_00__87c2538a_0e50_4bcc_ad0d_3bce06cea84b_:" 995(error not found).
V-79-65323-3202 - An error occurred on a query to database <Database_Name>
V-79-65323-3202 - Write on "<Database name>_dd8accd1_2684_450c_9149_f76416cef666_00__6b173f0a_2d8d_4c2f_9152_88f527b929c0_" failed: 995(error not found).
 

Environment



Following events are seen in the event viewer:

Event Type: Error
Event Source: Backup Exec
Event Category: None
Event ID: 57859
 
Description: An error occurred while executing the following query: "BACKUP DATABASE [Database_Name] TO virtual_device = "Database_Name_' WITH name = 'Backup Exec SQL Server Agent'". On server: "<server name>". SQL error number: "0C82". SQL error message: "Write on "Database_Name_" failed: 995(error not found)

Event Type: Error
Event Source: SQLVDI
Event Category: None
Event ID: 1
 
Description: SQLVDI: Loc=TriggerAbort. Desc=invoked. ErrorCode=(0). Process=2180. Thread=4888. Server. Instance=QM. VD=Global\Database_Name___SQLVDIMemoryName_0.


Cause



This is caused due to Virtual Device Interface (VDI), Backup Exec Agent for SQL server uses Virtual Device Interface (VDI) to backup the SQL databases.The SQL Server Virtual Device Interface (VDI) is implemented as a set of COM interfaces provided by Microsoft, if the issue still exists after performing the steps mentioned in the "Solution" section,then contact Microsoft for further troubleshooting.


Solution



1) If SQL 2005, SP2 or prior, apply the following Microsoft Hotfix.
 
2) If SP3, apply the cumulative update package 1 for SQL Server 2005 Service Pack 3. 
3) Ensure that Backup Exec Logon account has full administrative rights on the SQL server.

Supplemental Materials

SourceUMI
ValueV-79-65323-3271
Description

A nonrecoverable I/O error occurred on file.


SourceUMI
ValueV-79-65323-3202
Description

An error occurred on a query to database msdb.


SourceError Code
Value0xe0008492
Description

Database Query Failure.


SourceEvent ID
Value57859
Description

An error occurred while executing the following query: "BACKUP DATABASE ..."


SourceEvent ID
Value1
Description

SQLVDI: Loc=TriggerAbort. Desc=invoked. ErrorCode=(0). Process=2180. Thread=4888. Server. Instance=QM.


SourceEvent ID
Value18210
Description

BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device .


SourceUMI
ValueV-79-57344-33938
Description

Database Query Failure.



Legacy ID



350629


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


Terms of use for this information are found in Legal Notices