Ransomware attackers specifically target and attempt to destroy backup systems to increase the probability of payment. Hardening your system is critical. Please ensure you have reviewed your platform security using the Security Hardening Checklist
Cohesity

COHESITY Documentation

Explore our documentation to get started, discover products & new features, access troubleshooting guides, register sources, platforms support.

Products
Data Security Alliance
Visit Cohesity.com
Demos
Support
Blogs
Developers
Partner Portals
Cohesity Community
© 2026 Cohesity, Inc. All Rights Reserved.
Terms of Use|
Privacy Policy|
Legal|
  1. Home
  3. NetBackup™ for Microsoft SQL Server Administrator's Guide
  5. Protecting SQL Server availability groups
  7. Protecting SQL Server availibility groups with batch file-based policies
  9. About protecting the preferred replica in a SQL Server availability group (batch file-based policies)
  11. Configure an automatic backup policy for the preferred or the primary replica of a SQL Server availability group
NetBackup™ for Microsoft SQL Server Administrator's Guide

Configure an automatic backup policy for the preferred or the primary replica of a SQL Server availability group

This topic describes how to create a backup policy that uses batch files for automatic (scheduled) backups of the preferred or the primary replica in a SQL Server availability group. Create a policy for each type of backup that you want to perform. For example:

Policy A

Schedules: Full backup, run weekly

Backup Selections: Batch file for full backups

Clients: Node A, Node B, Node C

Policy B

Schedules: Differential backup, run daily

Backup Selections: Batch file for differential backups

Clients: Node A, Node B, Node C

Policy C

Schedules: Full backup, run per your RTO and RPO

Backup Selections: Batch file for transaction log backups

Clients: Node A, Node B, Node C

To configure an automatic backup policy for the preferred or the primary replica of a SQL Server availability group

  1. Sign in to the primary server as a user that has the RBAC Administrator role or a role that can manage policies.
  2. On the left, select Protection > Policies.
  3. Select Add.
  4. Type a unique name for the new policy.
  5. On the Attributes tab, configure the following:

    • Select the MS-SQL-Server policy type.

    • Specify a storage unit.

  6. On the Instances and databases tab, select Clients for use with batch files.

    The tab name changes to the name Clients. The Backup selections tab now lets you specify and browse for scripts.

  7. On the Schedules tab, add a Full backup schedule.

    NetBackup also creates a Default-Application-Backup schedule. Use this schedule to set the retention level for the policy.

  8. On the Clients tab, add the name of each replica on which you want backups to occur.

    Use the NetBackup client name for each replica. If a replica is hosted on a failover cluster instance (FCI), use the instance cluster name.

  9. Repeat step 3 to 8 in this procedure to create a policy for each type of backup (full, differential, transaction log) that you want to perform.

    Each type of backup requires a separate policy.

  10. On each replica where you want to perform backups, create a batch file for each type of backup that you want to perform.

    See Create batch files for the policy that protects the preferred or the primary replica.

More Information

About policy attributes

Schedule backup types for batch file-based policies

Feedback

Was this page helpful?
Previous

Prerequisites for protecting SQL Server availability groups

Next

Create batch files for the policy that protects the preferred or the primary replica

Feedback

Was this page helpful?