Friday, March 30, 2012

Instance rename

Is it possible to rename an instance?
I expect the answer is no , but.....
Thanks in advanceI don't think it's possible to rename an instance without reinstalling, or
at least I've never tried and never seen a technique documented.
You could, however, create an alias that points to that instance...
"Jim Campau" <Jim_Campau@.bausch.com> wrote in message
news:edPkJDYRDHA.2228@.tk2msftngp13.phx.gbl...
> Is it possible to rename an instance?
> I expect the answer is no , but.....
> Thanks in advance
>|||you have to rename the Computer to rename your SQL Server. If you are
talking about renaming a named instance of SQL Server, it's not possible.
To rename named instance of sql server:
Install new instance with the new name.
Move your databases from the old instance to the newly instance (using
backup/restore or DTS).
Uninstall the old instance.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_
afterinstall_5r8f.asp
-Vishal
"Jim Campau" <Jim_Campau@.bausch.com> wrote in message
news:edPkJDYRDHA.2228@.tk2msftngp13.phx.gbl...
> Is it possible to rename an instance?
> I expect the answer is no , but.....
> Thanks in advance
>

No comments:

Post a Comment