June 24, 2013 at 4:56 pm
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
June 25, 2013 at 7:10 am
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
:hehe: rookie here
June 25, 2013 at 4:17 pm
Thank you rajborntodare
June 25, 2013 at 9:41 pm
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.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply