Home Forums SQL Server 2008 SQL Server 2008 High Availability Can I restore the master and msdb dbs from a non-clustered instance to a cluster instance? RE: Can I restore the master and msdb dbs from a non-clustered instance to a cluster instance?

  • In a clustered environment there are various pieces of meta data that are stored which you wouldn't see in a standalone environment.

    Likelihood is if you do this it will fail to bring the instance online, never tried it myself and never would.

    Script the objects out and migrate them across, there are plenty of scripts available if you look, SSIS even has some builtin tasks for this too.

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

    "Ya can't make an omelette without breaking just a few eggs" 😉