-
Title
MS SQL Database backup fails with a 'Failed Request wide buffers on backup device' error. -
Description
NetVault Backup Environment details:
NetVault Server: 9.20 Build 17 Physical Machine Windows 2008 R2 64Bit.
NetVault Client: 9.20 Build 17 Physical Machine Windows 2003 Server 64Bit.
MS SQL Plugin: 6.1.2
SQL Server: 2005 Standard.
Backup Device: VTL on a SAN NetApp FAS2240 via iSCSI.
An MSSQL database backup fails with the following message:
Error 2014/07/04 12:33:05 148 Data Plugin CNV6 ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]BackupVirtualDeviceSet::SetBufferParms : échec Request large buffers sur l'unité de sauvegarde 'DELL_5524'. Erreur du système d'exploitation 0x8007000e(Insufficient memory for this operation).
With sub text :
ODBC Error Number:42000, MsgState=1, Severity=16, Servername=CNV6, ProcName=, LineNumber=1, Message:[Microsoft][ODBC SQL Server Driver][SQL Server]BackupVirtualDeviceSet::SetBufferParms : échec Request large buffers sur l'unité de sauvegarde 'DELL_5524'. Erreur du système d'exploitation 0x8007000e(Mémoire insuffisante pour cette opération.).
Error 2014/07/04 12:33:07 148 Data Plugin CNV6 Unexpected termination. -
Resolution
This points to the Client Operating System having resource problems as per the following link from IBM:
http://www-01.ibm.com/support/docview.wss?uid=swg21616078
IMPORTANT: The above IBM KBA and below information are provided as a general guidance and Quest Software, are not liable for any problem that arises following Microsoft configuration changes.
You should seek Microsoft expert advice to perform any Microsoft related troubleshooting or configuration change, and we recommend opening a case with Microsoft.
Are you using VSS as the backup job Backup Option as well?
Maybe there isn't enough free disk space for VSS and therefore causes a resource problem too?Please check the following for troubleshooting VSS issues:
1] Make sure the machine is patched with latest SP and VSS roll-up patches.
2] Check space: 30% free is needed for snapshots.
3] Memory fragmentation is a cause of VSS issues, so reboot if possible.
4] Verify VSS shadow copies are enabled for each of the drives to backup. (My Computer > right click drive > Properties > Shadow Copies).
5] Are there any other backups or applications trying to schedule a snapshot at the same time?
6] Run CHKDSK on each drive with the /f switch to fix any errors on the disk.
7] Make sure that the COM+ Event System service is set to Automatic.
8] Make sure Volume Shadow Copy service is set to Manual.
9] Having the SQL Database residing outside of the SQL Server on an external device can have an impact. Is this how the SQL Server is setup?
10] If we have unwanted shadows left over, then we need to clear them and attempt the backup again, so could you run the following command on the Client:
vssadmin delete shadows