Error the database could not be exclusively locked to perform the operation in D365
Views (2571)
dasdasd
841
Like
Share
Report
Recently I had a task to restore Microsoft Dynamics 365 database (AxDB), so for safe side I think I should keep my old database backup by only change it's name. When I done that error occurred that " Error: The database could not be exclusively locked to perform the operation" and it cannot let me rename the database as shown below.
When trying to rename manually it throws this error:
When trying to rename by SQL command it throws this error:
So after some research over internet I have found the reason and solution for this error. The reason of this error is that multiple connection is established with database that is why it cannot let me rename the database so in order to fix the issue I have to kill all the connections to the database. I use the ALTER DATABASE command to resolve the issue.
Solution:
When trying to rename manually it throws this error:
When trying to rename by SQL command it throws this error:
So after some research over internet I have found the reason and solution for this error. The reason of this error is that multiple connection is established with database that is why it cannot let me rename the database so in order to fix the issue I have to kill all the connections to the database. I use the ALTER DATABASE command to resolve the issue.
Solution:
- Set the database to single mode:
- ALTER DATABASE YourDatabaseName
- SET SINGLE_USER WITH ROLLBACK IMMEDIATE
- Try to rename the database:
- ALTER DATABASE YourCurrentDatabaseName MODIFY NAME = YourChangeDatabaseName
- Set the database to Multiuser mode:
- ALTER DATABASE YourChangeDatabaseName
- SET MULTI_USER WITH ROLLBACK IMMEDIATE
Result:
This was originally posted here.
*This post is locked for comments