Post reply

Recovering a clustered SQL Server to a non clustered one in a DR test.

  • February 28, 2011 at 10:36 am

    #247449

    I am working on a DR test and the recovery will be from a clustered server to a single stand alone. I'll be doing the base install. Historically I restore master & msdb before restoring the user databases.

    So my question is has anyone tried restoring a master db from a clustered install to a non-clustered one?

    Unfortunately I don't have a lot of information about the install yet. I got dropped into this at the last minute.

    Thanks for any help/opinions.

    Kenneth

    Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]

  • March 1, 2011 at 8:27 am

    #1292978

    hello,

    i have not tested this myself but this is possible. there is a lot of theory and some links in this post:

    http://social.msdn.microsoft.com/Forums/eu/sqldatabaseengine/thread/f33c89a4-6fe1-4e93-ba4b-348f3c442d05

    thanks

    lilywhites

  • March 6, 2011 at 1:04 pm

    #1295147

    totally possible, ensure the new server is the same build\version

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

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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply