SQL Server 2005: Rename DB Server Instance Name

database-administrationsql-server-2005

Can somebody tell me how to rename the DB server instance name and a DB name
in SQL Server 2005?

Right Now I Have 

SERVER/OLDNAME

-- oldnameDB

I want to change the server instance and also change the db name.

I have tried:

EXEC sp_renamedb 'oldName', 'newName'

and that has changed the dbname as it appers in the tree directory.
But, when I do "select @@servername" it is the old name. Also,
the MDF and LDF files are still the old name.

How do change instance and db names as a clean sweep across the server?

Thanks.

Best Answer

Note, there is no article in MSDN to rename instances. This may be the closest: How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server.

Frankly I'd reinstall if you want to chance instance name

sp_renamedb (deprecated, use ALTER DATABASE) will only change the name in sys.databases. You'll have detach, rename files, reattach. Or backup/restore WITH MOVE

Related Topic