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

Problem

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

 

Error Message

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

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.
 

Applies To

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.

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)