Error: Exclusive Access Could Not Be Obtained Because the Database is in Use. Restore Database is Terminating Abnormally
Exclusive Access Could Not Be Obtained Because the Database is in Use. Restore Database is Terminating Abnormally
Error :
Reason:
This error usually occurs when the database restore through the classical method is not working, i.e through Webgility Desktop app.
Resolution:
To resolve the error we need to restore the database through SQL Server Management Studio (SSMS) which involves a few steps. Here's a step-by-step guide:
Step 1:
Take the database backup you want to restore.
Step 2:
Open SQL Server Management Studio (SSMS) on your computer.
Step 3:
Connect to the SQL Server instance where you want to restore the database.
Step 4:
In the Object Explorer, go to the required database instance on which the restore needs to happen. Then right-click on it and navigate to Task> Restore> Database.
Step 5:
In the "General" page of the Restore Database window:
Select "Device" as the source.
Click the ellipsis (...) button to navigate to the location of your database backup file (.bak).
Step 6:
Select Backup File:
In the "Select backup devices" window:
Click "Add."
Navigate to and select your database backup file (.bak).
Click "OK."
Step 7:
Set Options:
Back in the "General" page of the Restore Database window:
Ensure that the correct backup file is listed under the "To database" field.
You can change the destination database name if needed.
Check the "Restore" options, such as "Overwrite the existing database" if you are replacing an existing database.
Step 8:
Specify a New Location for Data and Log Files (Optional):
In the "Files" page, you can specify new file locations for the database data and log files if needed. This step is optional.
Step 9:
Review and Start Restore:
Click on the "Options" page to review additional restore options.
Click "OK" to start the database restore process.
Step 10:
Monitor the Restore Process:
SSMS will display the progress of the restore operation. You can monitor the progress in the Messages tab.
Step 11:
Complete the Restore:
Once the restore process is complete, you will see a message indicating the success or failure of the operation.
**Note : This GIF shows steps from Step 6 to Step 11.
Step 12:
Verify the Restored Database:
In the Object Explorer, refresh the "Databases" node to see the newly restored database.
That's it! You have successfully restored a database backup through SQL Server Management Studio. Make sure to test the restored database to ensure data integrity and functionality.
If you have any questions or need more help, please contact our support team.