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
Find MSSQL Server Start Date & Time
How to Grant User / Group Access to SQL Server Database
Restore of database 'SID' failed. Exclusive access could not be obtained because the database is in ...
© 2017 ITsiti. All Rights Reserved
Powered by KEEM