Backup Exec cannot run a full backup of databases on a secondary node in a SQL availability group

Article:TECH217146  |  Created: 2014-04-30  |  Updated: 2014-06-23  |  Article URL http://www.symantec.com/docs/TECH217146
Article Type
Technical Solution


Issue



Backup Exec cannot run a full backup of databases on a secondary node in a SQL availability group. However, databases can be backed up and restored on the primary nodes in a SQL availability group. Full copy backups of the databases on the secondary nodes in a SQL Availability Group can also be run.


Error



The database is in a Microsoft Availability Group. This server is not currently the primary node for that group. Full backups are not supported on non-primary Availability group servers.

 


Cause



 Backup Exec 2014 does not support the backup and restore of databases on a secondary node in a SQL Availability Group.


Solution



Back up and restore databases or instances that are on the primary node in a SQL availability group. Note the following about this limited support:

  • Full backups and restores of databases on the primary node can be peformed.
  • Log backups and restores of a database on the primary node can be run.
  • Use the SQL Availability Groups tool to manually move a database back to an availability group after a restore.

Run full copy backups of databases or instances on a secondary node in SQL availability group. Note the following about this limited support:

  • Run full copy backups and restores of databases on the secondary node.
  • Log backups and restores of a database on a secondary node cannot be run.
  • Use the SQL Availability Groups tool to manually move a database back to an availability group after a restore and then synchronize with the primary node.

Supplemental Materials

SourceETrack
Value3491414


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


Terms of use for this information are found in Legal Notices