Backup of SQL database with Backup Exec fails with error: V-79-65323-942 - Database 'DatabaseName' cannot be opened because it is offline.

Article:TECH206101  |  Created: 2013-05-10  |  Updated: 2013-05-10  |  Article URL http://www.symantec.com/docs/TECH206101
Article Type
Technical Solution


Issue



Backup of SQL database with Backup Exec fails with error: V-79-65323-942 - Database 'DatabaseName' cannot be opened because it is offline.


Error



V-79-65323-942 - 
An error occurred on a query to database DatabaseName.
V-79-65323-942 - Database 'DatabaseName' cannot be opened because it is offline.
The item server.fqdn.com\DatabaseName in use - skipped.


Cause



One possible cause is a backup of the SQL database is already running from a 3rd party program.


Solution



1) Change the time of the Backup Exec SQL agent backup job to run at a time that doesn't conflict with the 3rd party program.

2) Change the start time of the 3rd party program to run at a time that doesn't conflict with the Backup Exec SQL agent.


Supplemental Materials

SourceError Code
ValueV-79-65323-942
Description

 Database 'DatabaseName' cannot be opened because it is offline.



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


Terms of use for this information are found in Legal Notices