Backing up read-write filegroups (SQL Server Intelligent 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
- 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, choose to Protect instances.
- Add the instances or the databases that contain the read-write filegroups.
See Adding instances to a policy (SQL Server Intelligent Policy).
- On the Backup Selections tab, select Whole database.
- Click the Microsoft SQL Server tab.
- Check Skip read-only file groups.
- When you have completed the policy configuration, click OK.