Rename a Database in SQL Server
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
Go to the location that
LDF filesare 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 Studioand right click on the DB and select