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

Problem

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

Error Message

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 does not support the backup and restore of databases on a secondary node in a SQL Availability Group.

Solution

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.

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 performed.
  • 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.
 

 

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)