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.
See About 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.
See Add instances to a policy.
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.

More Information

Back up read-only filegroups

Schedule properties for SQL Server Intelligent Policies

Performance tuning and configuration options

Back up read-write filegroups

Feedback

Feedback