Migrating sql instances from old 2012 cluster to new 2012 cluster

  • [font="Comic Sans MS"]Hi,

    Possibly, in a week's time we are to migrate around 4 sql clustered instances from the old box to the new cluster. However, what migration meant for me was to create new sql instances, and then as usual transfer the db's, logins etc to the new one and that's all, but here the problem is we need the same sql names to be used in the new cluster. I am not sure how to migrate this way, as I haven't done it before. It would be really helpful if someone can shed some light on this.

    Let me know if any additional details reqd.

    P.S: Both the old and new clusters will be in same domain, along with the same host OS Windows 2012 R2

    Regards,

    Faisal

    [/font]

  • I usually accomplish this with DNS names that are not the hostnames of the SQL Servers. You probably will not be able to set that up for the move next week, however. If you had the DNS names, you could transfer the logins and SQL Agent jobs over, and perhaps even mirror or log ship the databases over to the new server. In cases of databases in SIMPLE recovery mode, you can stage a full backup, and move a differential backup over on the day of the move (beware of large updates in nightly batch jobs, though). Once the databases are over, update the DNS entry, and then you have the web admins issue a ipconfig /FLUSHDNS on each server (preferably with a powershell script, instead of them logging in to each box separately).

  • [font="Comic Sans MS"]Thanks! Matt. Since, I haven't done this before could you pls. list out the steps one should take in order to complete this task.

    Regards,

    Faisal

    [/font]

  • faisalfarouqi (8/22/2014)


    [font="Comic Sans MS"]Hi,

    Possibly, in a week's time we are to migrate around 4 sql clustered instances from the old box to the new cluster. However, what migration meant for me was to create new sql instances, and then as usual transfer the db's, logins etc to the new one and that's all, but here the problem is we need the same sql names to be used in the new cluster. I am not sure how to migrate this way, as I haven't done it before. It would be really helpful if someone can shed some light on this.

    Let me know if any additional details reqd.

    P.S: Both the old and new clusters will be in same domain, along with the same host OS Windows 2012 R2

    Regards,

    Faisal

    [/font]

    Setup your new cluster with a new virtual IP and networkname. Once the migration has been completed take the old instance down and change the new instance to use the existing IP and networkname.

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

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

  • [font="Comic Sans MS"]Thanks! Perry. How do I make a change in the ip from the new ip to the old one. Could you pls. explain it step by step which would be easier to understand.

    Regards,

    Faisal

    [/font]

  • The links below detail how to change the IP and network name, you will of course have to ensure the resources are offline on the old cluster first.

    http://msdn.microsoft.com/en-us/library/ms178083.aspx

    http://msdn.microsoft.com/en-us/library/ms190460.aspx

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

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

  • Or rename the old cluster/nodes to "name_old" or something, rename the new cluster/nodes, and make sure it works before taking the old stuff all offline.

Viewing 7 posts - 1 through 7 (of 7 total)

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