Home Forums SQL Server 2005 Backups Restore System DBs to Another SQL Instance RE: Restore System DBs to Another SQL Instance

  • dso808 (8/12/2010)


    Hi and thanks so much for your help. Your suggestion sounds like the most feasible solution for our situation. We've also thought of perhaps setting up the DR server to mirror our user databases, recreate all logins, jobs, maintenance plans etc onto the DR server, and then make procedures so that going forward, all changes to our production server (the cluster) are also made to the DR server.

    But lesson learned. System database backups from a cluster should only be restored onto that cluster - NOT to another instance. Especially into an instance in a non-clustered environment.

    Any one else have input? Anyone else have a cluster with a non-clustered DR server backing it up? Whats the best way to set those 2 pieces up to play music together? Thanks again in advance to all who reply!

    you can restore the system databases on other instance, however the productversion(serverproperty('ProductVersion')) of other system should be the same, or otherwise it would not let you restore it.