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.

Article:TECH64494  |  Created: 2008-01-25  |  Updated: 2012-10-09  |  Article URL http://www.symantec.com/docs/TECH64494
Article Type
Technical Solution


Issue



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.


Error



Final Error Code: e0008492 HEX (0xe0008492 HEX) a0008492 HEX (0xa0008492 HEX).
Final Error Description: "Database Query Failure. See the job log for details."
Final Error Category: Resource Errors.
Error Text In Job Log: "An error occurred on a query to database ".

UMI:V-79-65323-18210 
 

Following events are logged in the event viewer:
 


 
Event Type: Error.
 
Event Source: Backup Exec.
 
Event Category: None.
 
Event ID: 57859.
 
Date: 10/15/2008
 
Time: 3:04:23 PM
 
User: N/A.
 
Computer: SharePoint.
 
Description:
 
An error occurred while executing the following query: "BACKUP DATABASE
 
[WSS_Content] TO virtual_device =
 
'WSS_Content_00__c1d3f9a0_99ee_4f7f_bb12_a6bf6bd1e712_' WITH name = 'Backup Exec
 
SQL Server Agent'".
 
On server: "SharePoint".
 
SQL error number: "0000".
 
SQL error message: "Connection failure.
 

 
Event Type: Error
 
Event Source: SQLVDI
 
Event Category: None
 
Event ID: 1
 
Date: 10/15/2008
 
Time: 3:04:25 PM
 
User: N/A
 
Computer: SharePoint
 
Description:
 
SQLVDI: Loc=CVDS::Close. Desc=Abnormal termination state. ErrorCode=(0).
 
Process=5228. Thread=7292. Client. Instance=OFFICESERVERS.
 
VD=Global\WSS_Content_00__c1d3f9a0_99ee_4f7f_bb12_a6bf6bd1e712__SQLVDIMemoryName_0.
 

 

 
Event Type: Error
 
Event Source: SQLVDI
 
Event Category: None
 
Event ID: 1
 
Date: 10/15/2008
 
Time: 3:04:25 PM
 
User: N/A
 
Computer:
 
Description:
 
SQLVDI: Loc=SignalAbort. Desc=Client initiates abort. ErrorCode=(0). Process=5228.
 
Thread=7292. Client. Instance=OFFICESERVERS.
 
VD=Global\WSS_Content_00__c1d3f9a0_99ee_4f7f_bb12_a6bf6bd1e712__SQLVDIMemoryName_0.
 

Solution



This issue is pertaining to SQLVDI (Virtual Device Interface) and is resolved by applying the Microsoft Hotfix as mentioned in the following article:
 

 
FIX: Error messages and an event may be logged when you use the Virtual Device Interface in SQL Server 2005 or in SQL Server 2000.
 

 

Supplemental Materials

SourceUMI
ValueV-79-65323-18210
Description

BackupVirtualDeviceSet::SetBufferParms: Request large buffers failure on backup device Operating system error 0x8007000e(Not enough storage is available to complete this operation.


SourceError Code
Value0xe0008492
Description

Database Query Failure. See the job log for details.


SourceEvent ID
Value57859
Description

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


SourceEvent ID
Value1
Description

SQLVDI: Loc=CVDS::Close. Desc=Abnormal termination state. ErrorCode=(0).
 



Legacy ID



312369


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


Terms of use for this information are found in Legal Notices