Rename a Database in SQL Server
Contents
-
Open
Microsoft SQL Server Management Studio
. -
Connect to the server where in the DB you want to rename is located.
-
Modify the following script and run it
|
|
-
Right click on the DB and select
Tasks>Take Offline
-
Go to the location that
MDF
andLDF files
are located and rename them exactly as you specified in first two alter commands. If you changed the folder path, then you need to move them there. -
Go back to
Microsoft SQL Server Management Studio
and right click on the DB and selectTasks>Bring Online
.