"Database cannot be opened. It is in the middle of a restore" occurs when trying to backup an SQL Database

Problem

Database cannot be opened. It is in the middle of a restore" occurs when trying to backup an SQL Database

Error Message

V-79-65323-927 - Database cannot be opened. It is in the middle of a restore

Cause

This error can also occur even if the SQL Database is not in the middle of a restore, but is instead in an offline or loading state.

Solution


Check to see what state the databases are in with the SQL Management Tools. If the databases are shown in a state in which a backup is not possible, deselect the databases from the selection list of the backup job or have an SQL Administrator address the situation to get the databases back online before attempting another backup.  


 

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)