The database could not be exclusively locked to perform the operation. (Microsoft SQL Server, Error: 5030)

You might have seen "The database could not be exclusively locked to perform the operation. (Microsoft SQL Server, Error: 5030)" error when you try to rename SQL server database.  This error normally occurs when your database is in Multi User mode where users are accessing your database or some objects are referring to your database.

 Nothing much to do to resolve the issue. First set the database to single user mode and then try to rename the database and then set it back to Multi user mode.

 We will go through step by step.

First we will see how to set the database to single user mode,

ALTER DATABASE dbName
SET SINGLE_USER WITH ROLLBACK IMMEDIATE

Now we will try to rename the database

ALTER DATABASE dbName MODIFY NAME = dbNewName


Finally we will set the database to Multiuser mode


ALTER DATABASE dbName
SET MULTI_USER WITH ROLLBACK IMMEDIATE
 

Hope you are able to rename your database without any issues now!!!

 

2 Comments

Comments have been disabled for this content.