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?
adam_daunhauerAsked:
Who is Participating?
 
Dan CraciunConnect With a Mentor IT 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

HTH,
Dan
0
 
Aneesh RetnakaranConnect With a Mentor Database 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

RESTORE FILELISTONLY  
FROM DISK = N'c:\temp.bak'
WITH NOUNLOAD;
GO
0
 
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
0
 
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
0
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.

All Courses

From novice to tech pro — start learning today.