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

Product(s)

Show all

Languages

Show all

Problem

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.

http://support.microsoft.com/kb/934396

2) If SP3, apply the cumulative update package 1 for SQL Server 2005 Service Pack 3.

http://support.microsoft.com/kb/959195

3) Ensure that Backup Exec Logon account has full administrative rights on the SQL server.

Supplemental Materials

Source	UMI
Value	V-79-65323-3271
Description	A nonrecoverable I/O error occurred on file.

Source	UMI
Value	V-79-65323-3202
Description	An error occurred on a query to database msdb.

Source	Error Code
Value	0xe0008492
Description	Database Query Failure.

Source	Event ID
Value	57859
Description	An error occurred while executing the following query: "BACKUP DATABASE ..."

Source	Event ID
Value	1
Description	SQLVDI: Loc=TriggerAbort. Desc=invoked. ErrorCode=(0). Process=2180. Thread=4888. Server. Instance=QM.

Source	Event ID
Value	18210
Description	BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device .

Source	UMI
Value	V-79-57344-33938
Description	Database Query Failure.

TECH67379 The error "Database Query Failure. See the job log for details" (e0008492 HEX or a0008492 HEX) is reported while Backing up Microsoft SQL 2000/2005 Databases

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

Legacy ID

350629