Rename a SQL Server instance

June 28, 2017

 

This week we do a change in our QA environment.

 

The architecture were looks like this –

Node1 – SQL Server 2014 Enterprise

Node2 – SQL Server 2014 Enterprise

 

Both of the nodes in Windows Server Failover Clustering (WSFC)

 

On the database-level we had high availability with AlwaysOn availability groups, the QA and the developers connected by listener.

 

This week we decided, that we do not need 2 nodes for this environment, and are feeling just fine with only single server.

 

So, the plan was to remove node 2 and to rename node 1 to the listener name.

That why the title name is - Rename a SQL Server instance :)

 

If you were looking online you probably run across this article - Rename a Computer that Hosts a Stand-Alone Instance of SQL Server

 

 

But, it’s not covered maintenance plan issues.

Day after the change we have found out that all our maintenance plan have failed.

That because, the old server name is embedded in the XML that contain the maintenance plan configuration.

 

There is a fix for this kind of action and it to rebuild etch maintenance plan.

Or, you can use this script:

I was advised by a post by NancySon and change it a bit in order to fit SQL Server 2014 instead of 2008.

That change the old name to the new one.

 

Hope that help you.

Please reload

Featured Posts

I'm busy working on my blog posts. Watch this space!

Please reload

Recent Posts

October 31, 2017

October 29, 2017

Please reload

Archive
Please reload

Search By Tags