SQL Restore Failing:Operating system error 1130(Not enough server storage is available to process this command.).

Posted on 2009-04-29
Last Modified: 2012-06-21
We have been experiencing an intermittent problem with the restore of a 50GB database to a SQL Server that runs under Windows 2003. The restore runs for 50 minutes or so, then dies with the following errors:

BackupMedium::ReportIoError: read failure on backup device '\\POSDBASE1\SQLBackups\Current\Autopart_Full.bak'.
Operating system error 1130(Not enough server storage is available to process this command.).

Internal I/O request 0x4372D888: Op: Read, pBuffer: 0x059D0000, Size: 65536, Position: 44023354880, UMS: Internal: 0x0, InternalHigh: 0xD197DC7C, Offset: 0x3FFF1600,
OffsetHigh: 0xA, m_buf: 0x059D0000, m_len: 65536, m_actualBytes: 0, m_errcode: 1130, BackupFile: \\POSDBASE1\SQLBackups\Current\Autopart_Full.bak

In the past, a reboot of POSDEVDB1 has cleared this up (for weeks at a time). Ive rebooted twice today and cannot get around this problem. I do not believe this is a SQL Server problem.

I can restore the SQL dump if I copy it locally. The problem seems to occur only when restoring over a newtork.

Any thoughts? Comments? Suggestions?
Question by:CiciO
    LVL 76

    Expert Comment

    Does the server where you are restoring the data have the 50GB on the drive to which you are restoring?
    During the restore configuration process, make sure to double check the location to which the data and log files are to be restored.  You might by accepting the default option are trying to restore the database in c:\program files\micorosoft SQL server\.... rather than on a different drive that you designated as the database data storage location.

    Do you have an option to copy the backup file such that it will be local to the system where the database will be restored?  Eliminating network hickup/saturation.

    Author Comment

    There is sufficient diskspace on the drive I am restoring to.

    Last night we rebooted BOTH machines (the machine we are restoring to, and the machine where the SQL Backup is located), and the process worked. We are temporarily "out of the woods" (till the next time).

    Still, I don't know what was "wrong". Why do I intermittently receive the "...1130(Not enough server storage is available to process this command.)..." error in the first place?
    LVL 76

    Expert Comment

    Next time, could you transfer the backup file to the system where the restore is taking place?
    Is log shipping setup an option?

    Author Comment

    I have had this happen on two machines (one is a development box, the other is used for reporting).
    The development box does not have sufficient diskspace for both the backup file and the database.
    The reporting machine does. I did copy the backup file to the reporting machine and was able to restore it.

    Log shipping is not an option.

    Again, I believe this is an OS issue. "...1130(Not enough server storage is available to process this command.)..."  seems to be a generic error.  If we can find out what causes it, we should be able to resolve it.
    LVL 76

    Accepted Solution

    A hickup in network traffic might be the issue.
    Did you try restoring from a mapped drive rather than a UNC path?
    Is there an anti-virus program running?

    In raw terms how much space do the data and log files take on the system where it is backed up?  Do they total 50GB or is the data file 40GB and the log file 30GB?
    How much space do you have on the system where you are restoring?
    Note: even though the backup file is 50GB of data, the restore process restores the files to the same size they are on the system.

    Author Comment

    My network guys tell me there were no network hiccups.

    I have NOT tried to restore from a mapped drive. I will try it next time it happens. Good suggestion.

    Norton Anti-Virus is running. I disabled it and still had the problem.

    The database takes up 54 GB, the log 7 GB.

    After the succesfull restore, there is 13 GB free.

    Author Closing Comment

    I never really got a solution. Noone else responded. Decided to close the issue.

    Expert Comment

    Seen this before on some servers when copying large files across the network.. solution below..


    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    Introduction: Sometimes when I receive a call from my users to solve their problems it is very difficult for me to found their computer IP address. Even finding their computer Host to provide remote support can be a problem.  So I resorted to Goo…
    The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
    This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
    Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now