-
Title
Exclusive access could not be obtained because the database is in use -
Description
Exclusive access could not be obtained because the database is in use during the SQL database restoration. -
Cause
Sometimes this is a common error message that we encounter, when we try to restore a SQL database, which is being used by other users. This can occur due to various reasons. But the most common incident is, users not closing the Management Studio’s query window after they have finished the query task.
-
Resolution
Please run the below script with help of your SQL admin.
alter database db_name
set offline with rollback immediate
alter database db_name
set onlineThis clears the connections and then you can try your restore. But sometimes that does not even work. Do the following.
Another solutions is to Right Click on Properties -> Options menu. At the bottom, Restrict Access option is set to MULTI_USER. Change it to SINGLE_USER. Then restore the database. After the restore, the Restrict Access will be changed back to MULTI_USER. Double check to be sure.