For some reasons, DBA's need to rename their Databases. One of the reasons might be to comply to Best Practices Policy changes. Here we are going to rename our Database named "Bad_Ass_DB" into "Best_Practice_DB".
This is how Database renaming with TSQL is done in SQL Server 2005:
First we need to put our Bad_Ass_DB offline or alter it to single-user mode. You cannot rename a database if it is online or in multi-user mode. And prior to that, there should be no active connection to the database (user, application, etc):
-
USE master
-
ALTER DATABASE Bad_Ass_DB
-
SET single_user
-
GO
Now we can rename the Database:
-
ALTER DATABASE Bad_Ass_DB
-
MODIFY NAME = Best_Practice_DB
-
GO
Then we can set the database back to multi-user mode. Then, real hard work begins: mapping all your codes, processess, applications, web.config, etc to the new name.
-
ALTER DATABASE Best_Practice_DB
-
SET multi_user
-
GO
-Marlon Ribunal Please Help Me: Here's How <Link>
[As Posted in my other blog http://dbalink.wordpress.com/]