Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2012 cluster - changing IPs and instance name Expand / Collapse
Author
Message
Posted Monday, June 24, 2013 4:56 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, June 20, 2014 3:29 PM
Points: 42, Visits: 242
We have SQL 2005 cluster (active-passive) in our production environment. Customer wants us to build new cluster with SQL 2012 active-passive configuration and run it in parallel with the existing SQL 2005 cluster for a while (the same network, the same subnet). Later on when all databases get migrated and apps get tested, the old cluster will be removed and the new cluster has to pick up the same IPs, names and instance names as the old had.
My concern is will we be able to make these changes (IPs, instance names) in SQL 2012 cluster environment and what problems (if any) we might run into?

Great thanks in advance for your opinion



Post #1466947
Posted Tuesday, June 25, 2013 7:10 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, February 11, 2014 10:12 AM
Points: 110, Visits: 501
Hi Alark,


I dont know about migration from 2005 to 2k12 and running them parllely for a while then to 2k12 completly..

But i can give u a little knowledge about the assigning the IP addresses...

When any application or service or system holding an IP address in shuted down or terminated... The IP address will be remained available for any other device..

In Failover cluster manager we have an option called add another resource for particular service or group...

Once you shutdown the old device, IP address would be readily available.. as you can assign to any by selecting the option i mentioned above...

I am not sure wether i am 100% sure

rookie here
Post #1467128
Posted Tuesday, June 25, 2013 4:17 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, June 20, 2014 3:29 PM
Points: 42, Visits: 242
Thank you rajborntodare


Post #1467403
Posted Tuesday, June 25, 2013 9:41 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 1:32 AM
Points: 1,155, Visits: 1,598
You can't rename an instance, so that method will not work.
Plus you'd be repointing your applications twice when once would be fine.
Post #1467431
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse