How to rename instance

31/03/2008, 19h38

Hi,
I installed sql05 on a new box and I don't like the name I chose for the
instance.
How do I change it?
TIA,
Mike

01/04/2008, 03h15

Backup your databases, uninstall SQL Server, install it properly, then
restore your databases. There is no sp_rename_instance.

"Mike" <mikenospam@yahoo.es> wrote in message
news:691977F7-8CB6-4107-B71E-6584B15311D4@microsoft.com...
> Hi,
> I installed sql05 on a new box and I don't like the name I chose for the
> instance.
> How do I change it?
> TIA,
> Mike
>

31/03/2008, 19h38	#1
Mike Messages: n/a Hébergeur:	How to rename instance Hi, I installed sql05 on a new box and I don't like the name I chose for the instance. How do I change it? TIA, Mike

01/04/2008, 03h15	#2
Aaron Bertrand [SQL Server MVP] Messages: n/a Hébergeur:	Re: How to rename instance Backup your databases, uninstall SQL Server, install it properly, then restore your databases. There is no sp_rename_instance. "Mike" <mikenospam@yahoo.es> wrote in message news:691977F7-8CB6-4107-B71E-6584B15311D4@microsoft.com... > Hi, > I installed sql05 on a new box and I don't like the name I chose for the > instance. > How do I change it? > TIA, > Mike >

Outils de la discussion
Afficher une version imprimable Envoyer un lien vers cette page par email