Backing up read-only 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. To back up read-only filegroups you must first create a separate policy for this type of backup. You can also verify that all read-only filegroups are backed up.
To back up read-only filegroups
- Open the NetBackup MS SQL Client interface.
- Create a batch file that includes the read-only filegroups.
All read-only filegroups must be included in some combination of full, or individual filegroup and file backups. You only need to perform this backup one time.
- In the NetBackup Administration Console, create a backup policy for read-only filegroups.
In the Application Backup schedule, set the Retention level of Infinite.
Add the batch file that you created to the backup selections list.
- Back up the read-only filegroups.
- If necessary, confirm all read-only groups are backed up by viewing the read-only backup set.