• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 403
  • Last Modified:

rename SQL instance ?

can you ( and how do you ) rename a SQL 2008 instance name ?
0
NAMEWITHELD12
Asked:
NAMEWITHELD12
  • 3
  • 2
4 Solutions
 
arnoldCommented:
Sp_dropserver current_servername
Sp_addserver newservername

This deals with a name change of the sever following a name change.

Instance changes, you mean you want to change server\instance1 to server\instance2?
0
 
NAMEWITHELD12Author Commented:
yeah , is there any way to do it in the GUI, I am trying to walk someone thru it over the phone

it will not effect any DBs ?

thanks!
0
 
arnoldCommented:
No, it is a TSQL. A non destructive process only taking effect after the sql service restarts.

Is this a clustered instance?

If I might, what is the reason for the change?
What is the expectation after the change?
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
NAMEWITHELD12Author Commented:
the reason is that I made a mistake on the naming of the instance ,


not clustered

I expect the DBs on the instance not to be affected in any way

thanks
0
 
arnoldCommented:
The example changes the name of the server, do not think you can change the second component.

Your best bet is to rerun the installer and add a new instance, then backup/restore the DBs

You have server\instanse and now you want to correct server\instance

This type of change can be done but is risky, deals with going through the registry .......
0
 
David ToddSenior DBACommented:
Hi,

If a new install then I suggest an uninstall/reinstall.

That way you wont be left wondering down the track if your registry hack has missed something.

I strongly recommend that you test any suggestions before applying to production. If you correction goes wrong you could be left with a horrible mess.

HTH
  David
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now