How can we help you today? How can we help you today?

SqlbackupC.exe crashes on 'Not enough Storage' error

I have a scheduled task that runs SQLBackupC.exe against two databases every hour. It has been running fine for weeks and this morning suddenly quit working. The one database is 8GB and the log is 400 MB. The second DB is under 2 GB and the log is only 25 MB. I have 66GB of free space on the data drive, and 4GB free on the OS drive. RAM is 2 GB. Every time it runs now I get the following entries in the event log:

BackupVirtualDeviceSet::SetBufferParms: Request large buffers failure on backup device 'SQLBACKUP_24445053'. Operating system error 0x80070008(Not enough storage is available to process this command.).

BACKUP failed to complete the command BACKUP LOG [stats] TO VIRTUAL_DEVICE = 'SQLBACKUP_24445053' WITH BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = '', DESCRIPTION = '', FORMAT

BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device 'SQLBACKUP_24445053'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).

And in the VDI.log I get:
2005/07/26 11:00:00 pid(804) tid(2032)
Error on Global\SQLBACKUP_24445053
Error at ServerBufferAreaManager::Allocate: Map buffers Status Code: 8, x8
Explanation: Not enough storage is available to process this command.


2005/07/26 11:00:01 pid(804) tid(2032)
Error on Global\SQLBACKUP_24445053
Error at TriggerAbort: invoked
2005/07/26 11:00:01 pid(1664) tid(2252)
Error on Global\SQLBACKUP_24445053
Error at CVD::GetCommand: AbortDetected
2005/07/26 11:00:01 pid(804) tid(1060)
Error on Global\SQLBACKUP_24445053
Error at TriggerAbort: invoked
2005/07/26 11:00:01 pid(804) tid(1060)
Error on Global\SQLBACKUP_24445053
Error at SVDS::CloseDevice: Abort detected
2005/07/26 11:00:01 pid(1664) tid(2252)
Error on Global\SQLBACKUP_24445053
Error at TriggerAbort: invoked
2005/07/26 11:00:01 pid(804) tid(1060)
Error on Global\SQLBACKUP_24445053
Error at TriggerAbort: invoked
2005/07/26 11:00:01 pid(1664) tid(2264)
Error on Global\SQLBACKUP_24445053
Error at TriggerAbort: invoked
2005/07/26 11:00:01 pid(804) tid(2032)
Error on Global\SQLBACKUP_24445053
Error at TriggerAbort: invoked


Thanks,
Rick
ihfrick
0

Comments

3 comments

Sort by
  • petey
    Are there any errors in the SQL Server errorlog file?
    petey
    0
  • ihfrick
    Only the same errors I get in the Event Log (as indicated below).

    BackupVirtualDeviceSet::SetBufferParms: Request large buffers failure on backup device 'SQLBACKUP_24445053'. Operating system error 0x80070008(Not enough storage is available to process this command.).

    BACKUP failed to complete the command BACKUP LOG [stats] TO VIRTUAL_DEVICE = 'SQLBACKUP_24445053' WITH BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = '', DESCRIPTION = '', FORMAT

    BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device 'SQLBACKUP_24445053'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).
    ihfrick
    0
  • petey
    The error is most likely due to a fragmented MemtoLeave (non-buffer pool). You can use VMStat to confirm this (a tool included with Microsoft's PSS labs http://www.microsoft.com/downloads/details.aspx?FamilyId=AEC18337-887F-4EC6-A858-81F84DE8082F&displaylang=en.

    There doesn't seem to be a way to resolve this other than restarting the service. You might want to try identifying the cause of the fragmentation instead.
    petey
    0

Add comment

Please sign in to leave a comment.