How to Rename a Database in Microsoft SQL

Microsoft SQL Server is the full version enterprise relational database server distributed by Microsoft. Microsoft SQL Server is managed by the SQL Server Management Studio, a GUI-based database management tool. The SQL Server Management Studio is used to rename a database in Microsoft SQL Server. First, restrict access to the SQL database so no other users attempt to make changes during the renaming process, and then rename the database in the "Properties" interface for the database.

Instructions

Restrict Access of the SQL Database to "Single-User Mode"

1. Click the Windows "Start" button and then click "All Programs".

2. Click the "Microsoft SQL Server" option to expand the folder, and then click the "Microsoft SQL Server Management Studio" link to open the management interface.

3. Click on the SQL Server to connect to in the left navigation pane of the Management Studio.

4. Right-click on the database to be edited, and click "Properties".

5. Click the "Options" selection.

6. Click "Single" in the "Restrict Access" section. If other users are connected, a dialog box will appear asking if you would like to disconnect other connections.

7. Click "Yes" to disconnect all other connections to the database.

8. Click "OK" and close the dialog box. Access is now restricted to "Single-User Mode" in the Management Studio.

Rename the SQL Database

1. Right-click on the database to rename the left pane of the Management Studio.

2. Select the "Rename" option.

3. Type a new name for the database in the input box and click "OK". The SQL database is renamed.

4. Reset the database back to "Multiple-User Mode" so other users may access the database.

References

• Microsoft: How to Set a SQL Database to "Single-User Mode"
• Microsoft: How to Rename a SQL Database