SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Not enough storage is available to complete this operation

This message appears in the TDP SQL dsmsched file.  It’s usually associated with low levels of contiguous memory

BackupVirtualDeviceSet::SetBufferParms: Request large buffers failure on backup device 'TDPSQL-00001BDC-0000'. Operating system error 0x8007000e(Not enough storage is available to complete this operation.). A nonrecoverable I/O error occurred on file "TDPSQL-00001BDC-0000:" 995(The I/O operation has been aborted because of either a thread exit or an application request.). BACKUP DATABASE is terminating abnormally.



 1) Likely SQL Server has run out of large memory blocks to allocate to the backup/restore process

 2) Monitor the memory usage pattern over time, with and without SQL Backup running. The numbers to look out for are the 'free' memory values

3) When a SQL Server backup fails due to the lack of a large enough contiguous block of free memory, SQL Backup automatically retries the backup using smaller MAXTRANSFERSIZE values, until it hits the minimum of 65536 bytes. 

 4) Immediate but drastic action may include restart of the SQL Server Instance. Proceed with caution and double check there aren’t open transactions .

 See Also

SQL Server Performance ,memory pressure and memory usage


Leave a comment on the original post [www.sqlserver-dba.com, opens in a new window]

Loading comments...