A SQL Server backup that captures only the data pages that have changed since the last full backup, but scoped to specific filegroups rather than the entire database.
- A differential backup captures all changes since the last full backup, while a partial differential backup limits this scope to specific filegroups: This approach is particularly useful for very large databases (VLDBs).
- Partial backups and partial differential backups allow DBAs to back up read-write filegroups more frequently: Read-only filegroups can be backed up less often, reducing backup time and storage requirements.
- This strategy is commonly used in data warehousing environments: Historical data filegroups are typically configured as read-only, while only the current-period filegroup receives ongoing updates.
- Restore sequences involving partial differential backups are more complex: DBAs should carefully plan and regularly test the complete restore procedure before relying on this strategy in production environments.
- Related terms: Differential Backup, Full Backup, Filegroup, Restore, VLDB.
