Home Forums SQL Server 2005 Administering restore failed: 1130(Not Enoughserver storage space) RE: restore failed: 1130(Not Enoughserver storage space)

  • 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