SQL DB Backup failure

  • Hi all,

    we are using TSM backup tool for SQL DB backup. From past two days the backups are getting failed due to following reasons.

    “BackupVirtualDeviceSet::Initialize: SetConfiguration failure on backup device 'TDPSQL-000012D4-0000'. Operating system error -2147024888(Not enough storage is available to process this command.)”

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

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

    we are using SQL server 2000 and 2005. can anyone help us on resolving these errors.

    Regards,

    Uma

  • Check free space on your database server. If it has enough, check your tape server.

  • Did you ever resolve this issue? If so, can you describe what you did to fix or was it simply a space issue for you? Many Thanks..

  • SQL Server is running out of memory. Try restarting the SQL Service. This will resolve the issue.

    If this issue reoccurs try increasing the memory_to_reserve by using -G switch as mentioned here

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply