• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 561
  • Last Modified:

trouble trying to restore a sql server 2005 db - getting error due to file size but there is plenty of space

I have a database running in sql server 2005 that I am trying to restore from a backup copy.
I know the backup copy is good because it worked one time.

When I run the restore I get this message in Management Studio when it gets to about 40%

Restore failed for Server 'name of server here' (Microsoft.SqlServer.SmoExtended)
Additional Information:
System.Data.SqlClient.SqlError: Read on "location of .bak file" failed:
1130(Not enough server storage is available to process this command.) (Microsoft.SqlServer.Smo)


The drive I am saving this to has 50GB of space and the file I am restoring from is only 20GB

It did work once, but I have not been able to get it to work since then.
I have even taking another backup and tried with that and had the same issue.

Any Ideas?
  • 2
2 Solutions
Dan CraciunIT ConsultantCommented:
Are you, by any chance, performing the restore over the network?
If so, you might need to increase IRPStackSize: http://support.microsoft.com/kb/285089

Aneesh RetnakaranDatabase AdministratorCommented:
>file I am restoring from is only 20GB
The backup file size could be 20GB,  when you restore the backup, it needs the space of the original mdf and ldf files , which could be more than 50GB , try running the command restore filelistonly and check for the size column

FROM DISK = N'c:\temp.bak'
adam_daunhauerAuthor Commented:
We have even tried saving it over to a server with 150GB free on it - I have my server guys looking into Dan's comment now
adam_daunhauerAuthor Commented:
we just ended up moving the .bak file to the same server that the restore was being done to and that worked - we will look into your other options at a later date. Thanks and I will split the points for your effort
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now