Forum Discussion

zahidashrafece's avatar
zahidashrafece
9 years ago

Transaction logs Backup when DB is in "AlWAYS ON" mode through Netbackup

Hello We have a request for configuring SQL Backups in Netbackup . We configured it through script in netbackup version 7.7.1 . FULL/INC backups are running fine but when comes to transection logs...
7.7
Backup and Recovery
NetBackup
Windows Server (2003-2008)
  • Marianne's avatar
    Marianne
    9 years ago

    I am reading the following in  NetBackup 7.7.1 for Microsoft SQL Server Administrator's Guide  :
    (Just a few extracts - more info in the manual)

    p.120:

    NetBackup can protect HA environments with SQL Server legacy backup policies. These environments include SQL Server AlwaysOn Availability Groups (AGs), SQL Server clusters, database mirroring, and log-shipping.

    Note: SQL Server AGs, SQL Server clusters, and database mirroring are not supported for SQL Server Intelligent Policy. Log-shipping environments are supported, but with the same caveats as for legacy SQL Server policies. See “Configuring NetBackup to support database log-shipping” on page 147.

    p.121:

    About using NetBackup to protect SQL Server availability groups

    NetBackup supports backups of AGs with legacy backup policies (with clients and batch files). Intelligent Policies do not support AG backups at this time.
    ■ You can protect an AG environment with a policy that protects the preferred replica or a policy that protects a specific node in the AG. See “About protecting the preferred replica in a SQL Server availability group” on page 122. See “About protecting a specific node in a SQL Server availability group” on page 127.

    p. 122:

    ■ Backups of non-readable secondary replicas
    NetBackup can only back up databases in a replica when you allow user connections for the replica.
    If a secondary replica is the preferred replica and it is non-readable, the backup fails. If a secondary replica is not the preferred replica, NetBackup skips the backup of that replica.

    ■ SQL 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 Backups of this type result in a failed backup.

    About protecting the preferred replica in a SQL Server availability group

    In the backup batch file that you create use the PREFERREDREPLICA TRUE keyword, which honors your SQL Server backup preferences. These preferences include the preferred replica, backup priority, and excluded replicas. Include this keyword in each backup operation in the batch file.
    ■ NetBackup backs up the preferred replica, as determined by SQL Server. NetBackup can only fully protect the AG environment if the backup policy includes each node in the AG in the Clients list. Also, all batch files in the Backup Selections list must exist on all the AG nodes.

    (Detailed info in the manual)

Marianne's avatar
Marianne
Level 6
9 years ago

I am reading the following in  NetBackup 7.7.1 for Microsoft SQL Server Administrator's Guide  :
(Just a few extracts - more info in the manual)

p.120:

NetBackup can protect HA environments with SQL Server legacy backup policies. These environments include SQL Server AlwaysOn Availability Groups (AGs), SQL Server clusters, database mirroring, and log-shipping.

Note: SQL Server AGs, SQL Server clusters, and database mirroring are not supported for SQL Server Intelligent Policy. Log-shipping environments are supported, but with the same caveats as for legacy SQL Server policies. See “Configuring NetBackup to support database log-shipping” on page 147.

p.121:

About using NetBackup to protect SQL Server availability groups

NetBackup supports backups of AGs with legacy backup policies (with clients and batch files). Intelligent Policies do not support AG backups at this time.
■ You can protect an AG environment with a policy that protects the preferred replica or a policy that protects a specific node in the AG. See “About protecting the preferred replica in a SQL Server availability group” on page 122. See “About protecting a specific node in a SQL Server availability group” on page 127.

p. 122:

■ Backups of non-readable secondary replicas
NetBackup can only back up databases in a replica when you allow user connections for the replica.
If a secondary replica is the preferred replica and it is non-readable, the backup fails. If a secondary replica is not the preferred replica, NetBackup skips the backup of that replica.

■ SQL 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 Backups of this type result in a failed backup.

About protecting the preferred replica in a SQL Server availability group

In the backup batch file that you create use the PREFERREDREPLICA TRUE keyword, which honors your SQL Server backup preferences. These preferences include the preferred replica, backup priority, and excluded replicas. Include this keyword in each backup operation in the batch file.
■ NetBackup backs up the preferred replica, as determined by SQL Server. NetBackup can only fully protect the AG environment if the backup policy includes each node in the AG in the Clients list. Also, all batch files in the Backup Selections list must exist on all the AG nodes.

(Detailed info in the manual)