Search <book_title>...

NetBackup™ for Microsoft SQL Server Administrator's Guide

Last Published: 2024-09-30

Product(s): NetBackup & Alta Data Protection (10.5)

Configure a batch file-based policy for a user-directed backup of read-write filegroups

When you separate read-only and read-write filegroups in your backup strategy, you can reduce total media usage and the total time you spend on backup operations. More information is available on backing up read-only filegroups.

Note:

Immediately back up any filegroup when you change it from read-write to read-only.

To back up read-write filegroups

Open the NetBackup MS SQL Client interface.
Select File > Backup SQL Server objects.
In the left pane, select the database instance.
In the right pane, select one or more databases that you want to back up.
Select the Type of Backup, as follows:
- To perform a full backup of the read-write filegroups, select Read-write filegroups.
- To perform a differential backup of the read-write filegroups, select Differential on read-write filegroups.
Select the backup options.
From the Backup script group, select Save.
Click Backup.
Note the location where the batch file is saved. This batch file is added to the policy that backs up the read-write filegroups.
Open the NetBackup web UI.
Create a backup policy for read-write filegroups.
- Create a Full backup schedule with the wanted retention period.
- Add the batch file that you created to the backup selections list.
(Optional) Manually back up the read-write filegroups.
If you do not perform a manual backup at this time, the backup runs automatically through the schedule you created in step 10.

More Information

Configure a batch file-based policy for a user-directed backup of read-only filegroups

Options for SQL Server backup operations