MSSQL database cannot be restored from backup: Exclusive access could not be obtained because the database is in use

Created:

2017-02-15 07:32:17 UTC

Modified:

2017-08-08 13:45:37 UTC

0

Was this article helpful?


Have more questions?

Submit a request

MSSQL database cannot be restored from backup: Exclusive access could not be obtained because the database is in use

Applicable to:

  • Plesk Onyx for Windows

Symptoms

During the restoration from the backup via CLI the following error message appears:

Failed deployment of database exampledb (domain example.com) 
Unable to restore MS-SQL database 'exampledb' to MS-SQL server '.\MSSQLSERVER2016'. Error info:
Exclusive access could not be obtained because the database is in use.

Cause

This is Plesk bug with ID #PPPM-5753 which is planned to be fixed in future Plesk updates.

Resolution

1. Got to the Plesk > Domains > example.com > Backup Manager .

2. Choose a backup that should be restored by clicking it.

3. Under the Restoration options check the option Suspend domains until the restoration is completed . Affected domains will be unavailable during the restoration process.

Have more questions? Submit a request
Please sign in to leave a comment.