Rename MSSQL Server Database

Share this article :

1. Ensure no one logged on to the database.

2. Restrict the access to single user mode.

3. Right click on the database instance and select Rename. You can rename the database now


4. Once renamed, you can put the access to multi user mode back.

Related posts

Check SQL Server Database Status
Find Last Database Backup & Log Backup for MSSQL Server
Determine MSSQL Server Collation
Shrink failed for LogFile 'XYZ' (Microsoft SQL Server)
© 2017 ITsiti. All Rights Reserved
Powered by KEEM