August 21, 2008 at 7:38 am
Hi,
We have several sql servers and a backup server to write all backups to this server. I try to get a backup of the largest database on a backup device. But i get the error below. For the other databases i don't have any problems. I have enough space on the backup server .
Any Idea ?
Executed as user: XX . 10 percent processed. [SQLSTATE 01000] (Message 3211) 20 percent processed. [SQLSTATE 01000] (Message 3211) 30 percent processed. [SQLSTATE 01000] (Message 3211) 40 percent processed. [SQLSTATE 01000] (Message 3211) 50 percent processed. [SQLSTATE 01000] (Message 3211) 60 percent processed. [SQLSTATE 01000] (Message 3211) 70 percent processed. [SQLSTATE 01000] (Message 3211) Write on "(\\XX\Backup\XX.bak)" failed: 1130(Not enough server storage is available to process this command.) [SQLSTATE 42000] (Error 3202) A nonrecoverable I/O error occurred on file "\\XX\Backup\XX.bak:" 1130(Not enough server storage is available to process this command.). [SQLSTATE 42000] (Error 3271) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013)
August 21, 2008 at 7:59 am
First be sure that you are actually backing up to the proper server.
Backups to remote servers aren't recommended as any network hiccup can fail the backup. If you must do this, be sure that the SQL Server service account, ro the Agent account has enough space visible. Just because there is space on the remote server doesn't mean the account sees that much space. You might try a dir from the SQL Server using one of those accounts.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
August 21, 2008 at 10:16 am
During the backup, does the kernel memory values (as viewed using the Windows Task Manager) increase linearly?
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
September 15, 2009 at 2:10 am
hi!!
I'm facing same errors in one of our production servers. where we are taking backups in a network location which we cant change to local as per client's request. But the backups were running fine till a week before but started failing from a week. There were no changes made to the server from a week.
Have tried taking manual backup at network location still it fails and the network server was having enough memory to take backups...
any help wud be appreciated
September 15, 2009 at 2:13 am
vishal (9/15/2009)
hi!!I'm facing same errors in one of our production servers. where we are taking backups in a network location which we cant change to local as per client's request. But the backups were running fine till a week before but started failing from a week. There were no changes made to the server from a week.
Have tried taking manual backup at network location still it fails and the network server was having enough memory to take backups...
any help wud be appreciated
Can you post the error that you are getting, most problems are down to lack of space. can you also post the size of the database/previous backups and the available size on the drive/volume you are backing up to.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 15, 2009 at 3:00 am
Below is the error im receiving :
Executed as user: 'Admin' . Write on "\etwork location" failed: 1130(Not enough server storage is available to process this command.) [SQLSTATE 42000] (Error 3202) A nonrecoverable I/O error occurred on file "\\\etwork location:" 1130(Not enough server storage is available to process this command.). [SQLSTATE 42000] (Error 3271) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
Size of entire backups was aroung 30GB and we have almost 235GB of freespace on the network drive where we are taking backups....
September 15, 2009 at 3:14 am
Hmm, not sure what to suggest. there are solutions to similiar problems out there, but they are more relevant to windows xp storage issues.
like changing the PagedPoolSize on the server
or changing the IRPStackSize on the server
just out of curiosity, is anti-virus running on the backup server and is it running a scan at either the times that the backup is occuring or does it have the database backup folder in its exclusion list.
I would be tempted to check the windows event logs to see if there are any other errors reported at this time.
I have also seen that installing sp1 has fixed it as well, if you have a windows 2003 server.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 15, 2009 at 3:19 am
This link might help you as well.
http://winwebhosting.net/iis/fix-not-enough-server-storage-is-available-to-process-this-command/
got tired of re-editing my post 😀
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 15, 2009 at 3:54 am
AV was not running....
server has SP2 already.. event logs giving same errors related to memory...
yes i got Microsoft article mentioning this issue related to pagedpooluseage..... I'm gonna try that option now ... lets c.....
September 17, 2009 at 3:33 am
HI,
changing pagedpool value in registry didnt helped... those backups jobs failed after running almost 10hrs
September 17, 2009 at 4:03 am
vishal-713648 (9/17/2009)
HI,changing pagedpool value in registry didnt helped... those backups jobs failed after running almost 10hrs
hmm ok, answer this for me then please.
Are all your databases backed up in one job, and if so is the database that it is failing on, the last database to be backed up.
and if so, can you put the backup for this database in a seperate job and try running it that way.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 17, 2009 at 5:31 am
yes im taking backup of all db's through a single SP.....
the job is failing for the first db itself
September 17, 2009 at 11:26 pm
vishal-713648 (9/17/2009)
yes im taking backup of all db's through a single SP.....the job is failing for the first db itself
To make sure where exactly the problem is, Can you please try to write your backup files to some other location? Maybe some other network drive.
October 7, 2009 at 10:34 pm
Deciding the current drive having some issue... we have changed our backup location to some other drive and now backups are fine.....
November 17, 2009 at 6:57 am
I backup local then move the backup file using Teracopy for exactly the reasons mentioned in the first reply. You can do it all via Agent and xp_cmdshell. More IO, but at least it works.
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply