Partial Backups (SQL Server)
Applies To: SQL Server 2016
All SQL Server recovery models support partial backups, so this topic is relevant for all SQL Server databases. However, partial backups are designed for use under the simple recovery model to improve flexibility for backing up very large databases that contain one or more read-only filegroups.
Partial backups are useful whenever you want to exclude read-only filegroups. A partial backup resembles a full database backup, but a partial backup does not contain all the filegroups. Instead, for a read-write database, a partial backup contains the data in the primary filegroup, every read-write filegroup, and, optionally, one or more read-only files. A partial backup of a read-only database contains only the primary filegroup.
File backups of read-only filegroups can be combined with partial backups. For information about file backups, see Full File Backups (SQL Server).
A partial backup can serve as the differential base for differential partial backups. For more information, see Differential Backups (SQL Server).
To create a partial backup
- BACKUP (Transact-SQL) (READ_WRITE_FILEGROUPS; FILEGROUP option, if needed)
To use a partial backup in a restore sequence