change Databasename

Question

How to Change DataBase Name in sql server 2008 r2

Robbinson · Answer

Hello You can rename database using below T-SQL script. USE master; GO ALTER DATABASE MyDB1 Modify Name = MyDBRename ; You can also do the same using SQL Server Management Studio tool. 1.In Object Explorer connect to an instance of the SQL Server Database Engine and then expand that instance. 2.Make sure that no one is using the database and then set the database to single-user mode. 3.Expand Databases right-click the database to rename and then click Rename. 4.Enter the new database name and then click OK. Hope this will help you out. Please don't forget to mark as answer if this post helps you.

Ranjit Powar · Answer

1. In Object Explorer  connect to an instance of the SQL Server Database Engine and then expand that instance. 2. Expand Databases right click the database to rename  and then click Rename. 3.Enter the new database name click Ok.