October 1, 2007 at 7:47 am
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
October 3, 2007 at 9:05 pm
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.
October 4, 2007 at 7:17 am
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.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 4, 2007 at 8:24 am
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
October 4, 2007 at 8:41 am
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