SQL Server DBA

Backup, restore, and recovery planning

Question

Full vs. differential backups: what does each contain, and when should each be used?

Answer

A full backup captures allocated extents; a differential captures extents changed since its differential base. Use full backups as restore-chain anchors and differentials to shorten restores between full backups. A differential does not reset the base.

This is 2 of 25 free samples for SQL Server DBA.

More SQL Server DBA topic samples