Scenario: Sometimes during renaming the Microsoft SQL Server database you might see the error, “The database could not be exclusively locked to perform the operation.Microsoft SQL Server, Error: 5030)” .
Reason: This error occurs when the database normally in the Multi User mode.
Resolution: Run the below commands to resolve the above issue
Alter the Database to single user mode
ALTER DATABASE dbname
SET SINGLE_USER WITH ROLLBACK IMMEDIATE
Rename the Database
ALTER DATABASE dbname MODIFY NAME = newdbName
Alter the database to multi user mode
ALTER DATABASE newdbName
SET MULTI_USER WITH ROLLBACK IMMEDIATE