Home Forums SQL Server 2005 Backups Restoring Back-Ups into a Different Server RE: Restoring Back-Ups into a Different Server

  • The backups store the path of each file that was backed up, by default a restore will restore these files to the same path.

    The trouble comes when restoring on a different machine where this path does not exist. If you're doing the restore through Sql Managment Studio then you can change the path each file will be restored to by going to the "Options" page and changing the "Restore As" value.