Webgility

Exclusive Access Could Not Be Obtained Because the Database is in Use. Restore Database is Terminating Abnormally

This error usually occurs when the database restore through the classical method is not working, i.e through Webgility Desktop app.

Restoring a database backup through SQL Server Management Studio (SSMS) involves a few steps. Here's a step-by-step guide:

Note: Before proceeding, make sure you make a backup file (.bak) of the Webgility database that you want to restore.

- Open SQL Server Management Studio (SSMS).
- Connect to the SQL Server instance where you want to restore the database.

- Connect to SQL Server:
 - Open SQL Server Management Studio (SSMS).
 - Connect to the SQL Server instance where you want to restore the database.

Locate the "Restore Database" Option:

- 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&gt; Restore&gt; Database.

- Locate the "Restore Database" Option:
 - 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&gt; Restore&gt; Database.

- 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).

- In the "Select backup devices" window:
 - Click "Add."
 - Navigate to and select your database backup file (.bak).
 - Click "OK."

- 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.

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.

- Click on the "Options" page to review additional restore options.
- Click "OK" to start the database restore process.

- SSMS will display the progress of the restore operation. You can monitor the progress in the Messages tab.

- Once the restore process is complete, you will see a message indicating the success or failure of the operation.

- Choose Source:
 - 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).
- Select Backup File:
 - In the "Select backup devices" window:
 - Click "Add."
 - Navigate to and select your database backup file (.bak).
 - Click "OK."
- 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.
- 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.
- Review and Start Restore:
 - Click on the "Options" page to review additional restore options.
 - Click "OK" to start the database restore process.
- Monitor the Restore Process:
 - SSMS will display the progress of the restore operation. You can monitor the progress in the Messages tab.
- Complete the Restore:
 - Once the restore process is complete, you will see a message indicating the success or failure of the operation.

- In the Object Explorer, refresh the "Databases" node to see the newly restored database.

- 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.