Back up read-only 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. 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
- Create a new policy to protect read-only filegroups.
- Select the policy attributes.
- Create a Full backup schedule and set the Retention level to Infinite.
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.
- Choose to protect instances and databases or instance groups.
- On the Backup selections tab, select Filegroups.
- Select the filegroups you want to back up.
- When you complete the policy configuration, click Create.
- Back up the read-only filegroups.
- If necessary, confirm that all read-only groups are backed up by viewing the read-only backup set.