locked
SQL Cluster Migration RRS feed

  • Question

  • Dear all , 

    i have currently SQL Server 2005 and i need to move to new SQL server 2012 and migrate the database .

    i will be doing SQL Cluster and create two new node for the new sql server and then use the backup and restore for the databases .

    is there a way to keep the old sql server name instead of giving new name for the new server ?

    Monday, August 24, 2015 12:29 PM

Answers

  • Essentially no there is no issue when renaming A Server; you can have issues when moving a Server to a different domain but in the scenario you are not doing this.

    It has been a while since I did this but the basic steps I outlined above are what is required.  However engage with your Network Team so they can offer support/advice etc.


    Please click "Mark As Answer" if my post helped. Tony C.

    • Proposed as answer by Anthony C-UK Tuesday, August 25, 2015 11:46 AM
    • Marked as answer by Charlie Liao Wednesday, September 9, 2015 3:38 AM
    Monday, August 24, 2015 1:37 PM

All replies

  • Are you talking about windows or SQl Server instance name ?


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Technet Wiki Article

    MVP

    Monday, August 24, 2015 12:50 PM
  • it's been a while but essentially yes.

    Build your new cluster with different a cluster name; perform the migrations, rename your old cluster and give it a different I.P. Address and the rename your new cluster to preferred name and also alter the I.P. Address to suit.

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

    For obvious reasons engage Your Network Team to help out with this...


    Please click "Mark As Answer" if my post helped. Tony C.

    • Proposed as answer by Anthony C-UK Tuesday, August 25, 2015 11:46 AM
    Monday, August 24, 2015 12:51 PM
  • hi 

    sql server name (windows ) 

    Monday, August 24, 2015 1:20 PM
  • hi , 

    renaming the sql cluster and server doesn't make any issue later on ?

    since this server is part of domain and there will be databases also 

    Monday, August 24, 2015 1:22 PM
  • Essentially no there is no issue when renaming A Server; you can have issues when moving a Server to a different domain but in the scenario you are not doing this.

    It has been a while since I did this but the basic steps I outlined above are what is required.  However engage with your Network Team so they can offer support/advice etc.


    Please click "Mark As Answer" if my post helped. Tony C.

    • Proposed as answer by Anthony C-UK Tuesday, August 25, 2015 11:46 AM
    • Marked as answer by Charlie Liao Wednesday, September 9, 2015 3:38 AM
    Monday, August 24, 2015 1:37 PM
  • hi , 

    renaming the sql cluster and server doesn't make any issue later on ?

    since this server is part of domain and there will be databases also 

    The whole point is how correctly you do it. This is done many a times by many DBA's so this wont be problem as such unless you know system well and make sure this is edited wheever name is used

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Technet Wiki Article

    MVP

    Monday, August 24, 2015 1:49 PM
  • Read this link - https://msdn.microsoft.com/en-us/library/ms143799.aspx


    Regards, Ashwin Menon My Blog - http:\\sqllearnings.com

    Monday, August 24, 2015 7:07 PM