Backing up read-only 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. 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 or instance groups.
See Adding instances to a policy (SQL Server Intelligent Policy).
See Adding instance groups to a SQL Server Intelligent Policy.
- On the Backup Selections tab, select Filegroups.
- Select the filegroups you want to back up.
- When you complete the policy configuration, click OK.
- Back up the read-only filegroups.
- If necessary, confirm all read-only groups are backed up by viewing the read-only backup set.
More Information
Backing up read-write filegroups (SQL Server Intelligent Policies)
Reducing backup size and time by using read-only filegroups
Viewing SQL Server read-only backup sets
About schedule properties (SQL Server Intelligent Policy)
Adding SQL Server filegroups or files to the backup selections list