Solved

Rename sql server 2012 cluster instances on active active cluster

Posted on 2014-09-25
2
277 Views
Last Modified: 2014-10-09
Hello All,

I have set up a active/active cluster with two nodes

Physical Nodes:
MATLKBIR1CLP001
MATLKBIR1CLP002

Windows cluster name
MATLKBIR1VLP001

sql groups
sql group 1
sql group 2

Sql Virtual instance names
First instance:MATLKBIR1SQP001
Second Instance:MATLKBIR1SQP002

The cluster is up and running however I need to change the sql instance names
MATLKBIR1SQP001 to MATLKBIR1SQP003
MATLKBIR1SQP002 to MATLKBIR1SQP004

I have following questions to be answered
1.Can we change the instance names without effecting entire windows and sql clusters?
2.if yes, what is the process should be followed
3.if there is any issue, how do we roll back
4.Any Ramifications/issues of after  doing the instance name changes during failover/failback process.
0
Comment
Question by:chandradineshbabu
2 Comments
 
LVL 45

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 40345607
Those instances have databases? If not I will recommend you to uninstall them and install new instances.
If you want to go forward with this, here's the MSDN article on how to do it.
0
 

Author Closing Comment

by:chandradineshbabu
ID: 40372284
Thanks for the solution
0

Featured Post

Why spend so long doing email signature updates?

Do you spend loads of your time carrying out email signature updates? Not very interesting are they? Don’t let signature updates get you down. Let Exclaimer Cloud - Signatures for Office 365 make managing email signatures a breeze.

Join & Write a Comment

Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now