restore failed: 1130(Not Enoughserver storage space)

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » restore failed: 1130(Not Enoughserver storage...

restore failed: 1130(Not Enoughserver storage space)

Rate Topic

Display Mode

Topic Options

Author

Message

MAK-1128556

Posted Wednesday, July 22, 2009 12:59 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 01, 2010 7:44 AM
Points: 176, Visits: 290

Hi,

I do have a enough space in a server D: and E: drive, I reboot the server too, but still getting a following error

System.data.sqlClient.sqlError:Read on
"z:\databame" failed: 1130(Not Enoughserver storage is avaliable to process this command)(Microsoft.sqlserver.smo)

Post #757793

John Rowan

Posted Wednesday, July 22, 2009 1:43 PM

Hall of Fame

Group: General Forum Members
Last Login: Tuesday, January 29, 2013 10:54 AM
Points: 3,837, Visits: 3,821

Where is the backup from, another server? How are you doing the restore, SSMS or script? What are you trying to do, restore a Production DB, create a new DB from a backup?

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden

Post #757822

MAK-1128556

Posted Wednesday, July 22, 2009 1:54 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 01, 2010 7:44 AM
Points: 176, Visits: 290

I want to restore the last night full db backup from production to test, I delete the test db, I am using simple restore process, Database, restore databse and defne the db name and backup files name (network files)

Post #757832

Senthil Kumar Rajendran

Posted Wednesday, July 22, 2009 1:57 PM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 11, 2012 4:24 AM
Points: 83, Visits: 72

Mak

Check whether your test server has enough drive space. If yes then copy the Backup file from production and paste it in test server and then restore it.

If your script throwing an error then do it through SSMS, so you can easily restore it to the test server.

Regards,

RSK....

Post #757835

MAK-1128556

Posted Wednesday, July 22, 2009 2:03 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 01, 2010 7:44 AM
Points: 176, Visits: 290

thanks, I will try Smile

Post #757839

John Rowan

Posted Wednesday, July 22, 2009 2:08 PM

Hall of Fame

Group: General Forum Members
Last Login: Tuesday, January 29, 2013 10:54 AM
Points: 3,837, Visits: 3,821

Keep in mind that the data and log file physical path/names are stored in the backup header so you need to make sure your restore is moving the files to the new drive/path/filename of your test server.

Use RESTORE FILELISTONLY FROM DISK='your backup file path/name' to find out the production path.

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden

Post #757846

MAK-1128556

Posted Wednesday, July 22, 2009 2:14 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 01, 2010 7:44 AM
Points: 176, Visits: 290

Thanks

Post #757851

« Prev Topic | Next Topic »

Permissions