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

Stop & Start MSSQL Server 2005
Detach & Attach SQL Server 2008 R2 Database
How to Grant User / Group Access to SQL Server Database
SQL: No process is on the other end of the pipe
© 2017 ITsiti. All Rights Reserved
Powered by KEEM