Solved

Rename sql server 2012 cluster instances on active active cluster

Posted on 2014-09-25
2
316 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 48

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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
When you try to extract and to view the contents of a Microsoft Update Standalone Package (MSU) for Windows Vista, you cannot extract the files from the MSU. Here we are going to explain how to extract those hotfix details without using any third pa…
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

809 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