Notes on SQL

Random articles from a puzzled DBA

Background

Whilst watching a Pluralsight training course by Paul Randal, on ‘Logging, Recovery and the Transaction log’, a particular snippet related to differential backups piqued my curiosity.

Basically, does a differential backup only take backups of altered pages, within a database.

The short answer is ‘yes’, but the detail is a little bit more interesting than that.

Continue reading