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

Install Microsoft SQL Server 2008 R2 using SQL4SAP
SQL Server Native Client Installation Steps
Detach & Attach SQL Server 2008 R2 Database
How to Activate xp_cmdshell Server Configuration Option
© 2017 ITsiti. All Rights Reserved
Powered by KEEM