NetBackup for Microsoft SQL Server Differential backup of AlwaysOn Availability Group secondary replica fails with Status Code 2 or 6

Article: 100055157
Last Published: 2023-02-20
Ratings: 0 1
Product(s): NetBackup & Alta Data Protection

Problem

NetBackup for Microsoft SQL Serer Differential backup of AlwaysOn Availability Group databases failed with Status Code 2 or 6

Error Message

Database <DB01> is hosted on an Availability Group secondary replica, Differential backups are not supported.

Cause

MSSQL Server does not support the following types of backups on a secondary replica:
■ Full backups
If a full backup takes place on a secondary replica, NetBackup converts the full backup to a copy-only backup.
■ Differential backups
Backups of this type result in a failed backup.
■ Copy-only transaction log backups
Protecting SQL Server availability groups 
Backups of this type result in a failed backup.

Solution

If you want to backup from secondary, please run full backup with copy-only, it doesn't support differential backup.

Or please backup it from primary, which can support full, differential and logs backup.

Was this content helpful?