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)
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)