Creating a batch file for the policy that protects a specific node in an availability group
This topic describes how to create batch files for the backup policies that protect a specific node in the availability group (AG).
To create batch files for the policy that protects a specific availability group node
- This procedure assumes that you already created a policy.
See Configuring an automatic backup policy for a specific node of a SQL Server availability group.
- Log on to the AG node that hosts the replica you want to protect.
- Open the NetBackup MS SQL Client.
- Select File > Set SQL Server connection properties.
- From the Instance drop-down list, select the instance that hosts the AG.
- Select File > Backup SQL Server objects.
- Select the objects you want to backup in one of the following ways:
Select one or more databases, filegroups, or files.
To back up all databases, including the system databases (DATABASE $ALL), select the instance. From the Back up group, select All.
- Select the Type of Backup and any other settings.
- In the NetBackup Policy field, enter the name of the MS-SQL Server policy that you created.
- From the Backup script group, select Save.
- Click Backup and save the batch file.
Do not use the PREFERREDREPLICA TRUE keyword in your batch files. Backups are skipped if the backup policy does not include the node that hosts the preferred replica.
- Repeat steps 6 to 11 for any other the types of backups that you want to perform. For example, full, full differential, or transaction log.
More information is available on how to create batch files.
- When you have created all the batch files, add these files to the policies that you created previously.
See Adding the batch files to the policy that protects a specific node in the availability group.