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

MSSQL Server Database Backup & Restore vis SQL Management Studio
Restrict Access to SQL Server Database
Disconnect / Kick All Users from MSSQL Server Database
Shrink failed for LogFile 'XYZ' (Microsoft SQL Server)
© 2017 ITsiti. All Rights Reserved
Powered by KEEM