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

Article:TECH128042  |  Created: 2010-01-26  |  Updated: 2011-08-15  |  Article URL http://www.symantec.com/docs/TECH128042
Article Type
Technical Solution


Issue



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


Error



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.  


 

Supplemental Materials

SourceUMI
ValueV-79-65323-927
Description

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



Legacy ID



347991


Article URL http://www.symantec.com/docs/TECH128042


Terms of use for this information are found in Legal Notices