Because I currently had the task …
A customer wanted a new server, identical to the existing test or development environment.
Background:
The customer owns a server with two instances (test and development) and now wants a server for the production environment …
Our VMWare colleagues suggest a one-to-one clone, the customer agrees.
So what about the MSSQL installations? Can you rename?
Just asked Google and received contradictory results, especially since this is not the default instance but two named instances:
At least since MSSQL 2005 there are the StoredProcedures sp_dropserver and sp_addserver, which do not necessarily indicate the function of renaming, but they fulfil the desired functions.
-– Determine the current name of the instance
SELECT @@servername
-- Remove the instance from the server list
EXEC master.dbo.sp_dropserver ‘[SERVER NAME]‘
-- Add the "new" instance as a new local server
EXEC master.dbo.sp_addserver ‘[NEW SERVER NAME]‘, ‘local’
Restarting renamed SQL Server Instance
-- checking the new instance name
SELECT @@servername
The second instance could just be uninstalled, VMWare colleagues happy, DBAs happy and customer satisfied.
Björn works in Hamburg as Senior Consultant – Microsoft Data Platform and Cloud at Kramer & Crew. He regularly participates in the PASS regional group meeting in Hamburg, the events of the PASS such as SQLSaturday and DataGrillen and organises the Azure Meetup in Hamburg. He is interested in topics such as SQL Server, Powershell and Azure for science fiction, snowboarding, baking and cycling.