Backing up read-write filegroups (legacy SQL Server backup policies)
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 Backup Microsoft SQL Server Objects dialog box, 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 Administration Console.
- 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.