Home Forums SQL Server 2005 Backups Restoring from one instance to another... RE: Restoring from one instance to another...

  • no probs.

    FILE =1 should not be necessary. If you are always backing up to the same backup file name ensure you use the init clause in the backup, otherwise it will be appending and the backup fie will grow very large.

    after the restore you may also need to change the database owner and synch orphaned user ids.

    ---------------------------------------------------------------------