Back up 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
- Create a new policy or open the policy you want to configure.
- Select the policy attributes.
- Create a Full backup, Differential incremental backup, and Transaction log backup schedule.
- On the Instances and databases tab, select Protect instances.
- Add the instances or the databases that contain the read-write filegroups.
- On the Backup selections tab, select Whole database.
- Click the Microsoft SQL Server tab.
- Select Skip read-only file groups.
- When you have completed the policy configuration, click Create or Save.