SQL Server 2005 Backup Maintenance Plan failing

  • I am not using a 3rd party backup utility but a SQL Server Maintenance Plan. I have 2 such plans, one works and one has consistently failed.

    This is the error in the error log:

    BackupDiskFile::RequestDurableMedia: failure on backup device '\\my server\MARS_SQL_BACKUPS\data\pp_daily.bak'. Operating system error 1130(Not enough server storage is available to process this command.).

    I've substituted the real name of the file server with my server just in case someone is wondering.

    I am backing up the databases to a file server that has plenty of room. I've manually run the backup, watched the backup grow in size until the error is thrown, where by the backup is deleted.

    I'm developing a work-a-round. I have found that I have enough room on the local server for a backup. I've modified my maintenance process to back up locally then simply copy the backup file to the file server that contains all of my other backups. I will see if that works..

    Any ideas?

    Kurt

    DBA

    RHWI

    Poughkeepsie, NY

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

  • I'm not sure, but I could see that a quota on the file server could be causing issues.

    Backing up to network drives is not recommended. The SQL backup program is very intolerant of any network delay, unlike a copy.

  • Steve is correct in saying that backing up to a network drive is very fussy. I was doing this in my last job and found that once a backup got above 4GB in size I would regularly get this problem so we moved away from using network drives.

    I would guess that your solution using a local backup and then a copy to the network location will probably work, unless there is a quota on the file server that is causing the error.

  • Thanks Guys for your response. In my efforts to find a solution I discovered a few things. 1) I found that I have enough room on the same box to create a backup, which I was able to successfully do last night. 2) I created a separate step to perform a file copy, which according to the log ran successfully however it wasn't on the file server. Therefore I executed the copy command from DOS and it failed with the same error. Yes folks.. didn't have enough space for the backup... :Whistling:

    That what happens when I listen to the Network Administrator who tells me "... ahhh there's plenty of room for your backups..." only to find out he took 3/4 of the space for rerunning a big job... :pinch:

    I can't thank you guys enough.

    Kurt

    DBA

    RHWI, Inc

    Poughkeepsie, NY

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

  • Kurt,

    Glad you figured it out, thanks for the update and glad we could help.

    Gotta double check those network admins 🙂

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

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