adam_daunhauer
asked on
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.SmoEx tended)
Additional Information:
System.Data.SqlClient.SqlE rror: 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?
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.SmoEx
Additional Information:
System.Data.SqlClient.SqlE
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
ASKER