This is not for releasing the occupied database but it's necessary to perform in advance! You don't wish to disconnect a user who is doing a very important task without a notification.
Usually, administrators use the built-in systems sp_who & sp_who2 to find processes and users using the database. Since the error message hints that someone is using the database, you need to check who it is and how to notify him/her to stop it. Next, we advise users to go through the four procedures to rectify the problem. It's possible to restart the Server service as the StackOverflow user does, but do not take it as the first step regarding the data safety. Solutions - How to Fix Database in Use ProblemĪpplies to: MS SQL Server 2000, 20005, 2008, 2008 R2, 2012, 2014, 2016, 2017.Īny version of SQL Server, when this kind of problem occurs, can benefit from the provided solutions here. Usually, the full error message is like this.Īdditional Information: : Exclusive access could not be obtained because the database is in use. As you see, when we try to restore a database in Microsoft SQL Server Management Studio (SSMS), it does not work because some other users are currently using the database, too.
There is always an error that the database is in use until I restart the SQL Server service." "I'm using SQL Server 2008 R2, I need to restore a database from a.
0 kommentar(er)
