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
SQL Server Native Client Installation Steps
SQL: No process is on the other end of the pipe
How to Activate xp_cmdshell Server Configuration Option
© 2017 ITsiti. All Rights Reserved
Powered by KEEM