SQL Backups or Restore fail with the error "BackupVirtualDeviceSet::SetBufferParms: Request large buffers failure on backup device Operating system error 0x8007000e(Not enough storage is available to complete this operation."

Article:TECH128837  |  Created: 2010-01-15  |  Updated: 2014-01-14  |  Article URL http://www.symantec.com/docs/TECH128837
Article Type
Technical Solution


Issue



SQL Backups or Restore fail with the error "BackupVirtualDeviceSet::SetBufferParms: Request large buffers failure on backup device Operating system error 0x8007000e(Not enough storage is available to complete this operation."

This issue has been noticed while working with Netbackup Application as well and the Status Code 2 was received on the Netbackup end for this issue.

 


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: SQLserver
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: Event Source: Backup Exec
 
Event Category: None
 
Event ID: 57859
 
Date: 2/3/2010
 
Time: 4:14:32 PM
 
User: N/A
 
Computer: BIGOTEST
 
Description:
 
An error occurred while executing the following query: "RESTORE DATABASE [restorebigotires] FROM virtual_device = 'restorebigotires_00__d6fba704_c592_46d4_9ff0_efbb71f15c5f_' WITH NORECOVERY , MOVE 'bigotiresdata' TO 'f:\program files\microsoft sql server\mssql\data\restorebigotires_data.mdf', MOVE 'bigotireslog' TO 'f:\program files\microsoft sql server\mssql\data\restorebigotires_log.ldf'".
 
On server: "BIGOTEST".
 
SQL error number: "0BC5".
 
SQL error message: "RESTORE DATABASE is terminating abnormally".
 
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.
 

 
Event Source: Backup Exec
 
Event Category: None
 
Event ID: 57859
 
Date: 2/3/2010
 
Time: 4:14:32 PM
 
User: N/A
 
Computer: BIGOTEST
 
Description:
 
An error occurred while executing the following query: "RESTORE DATABASE [restorebigotires] FROM virtual_device = 'restorebigotires_00__d6fba704_c592_46d4_9ff0_efbb71f15c5f_' WITH NORECOVERY , MOVE 'bigotiresdata' TO 'f:\program files\microsoft sql server\mssql\data\restorebigotires_data.mdf', MOVE 'bigotireslog' TO 'f:\program files\microsoft sql server\mssql\data\restorebigotires_log.ldf'".
 
On server: "BIGOTEST".
 
SQL error number: "0BC5".
 
SQL error message: "RESTORE DATABASE is terminating abnormally".
 

Environment



Netbackup 6.5.6 Master\Media Server on Linux
Netbackup 6.5.6 Client Server on Windows


Cause



This is a BUG from SQL 2005 end and Microsoft have acknowledged that this is a known issue.


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
 
It is written in the KB Article that this patch should be installed on MS-SQL 2005 SP2 and no reboot is required after applying this patch.
 

 

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
Value0x8007000e
Description

Not enough storage is available to complete this operation.


SourceError Code
Value0xe0008492
Description

An error occurred on a query to database


SourceEvent ID
Value57859
Description

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


SourceEvent ID
Value1
Description

SQLVDI Error



Legacy ID



350360


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


Terms of use for this information are found in Legal Notices