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 …

Continue reading