Post reply

restore failed: 1130(Not Enoughserver storage space)

  • July 22, 2009 at 12:59 pm

    #134456

    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)

  • July 22, 2009 at 1:43 pm

    #1028643

    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[/url] - by Jeff Moden

  • July 22, 2009 at 1:54 pm

    #1028650

    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)

  • July 22, 2009 at 1:57 pm

    #1028652

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

  • July 22, 2009 at 2:03 pm

    #1028655

    thanks, I will try:-)

  • July 22, 2009 at 2:08 pm

    #1028660

    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[/url] - by Jeff Moden

  • July 22, 2009 at 2:14 pm

    #1028664

    Thanks

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply