Press "Enter" to skip to content

Differential Backups of Master

Kenneth Fisher abides by Betteridge’s Law of Headlines:

In one of the sessions I attended during the Pass Data Community Summit the speaker asked “If master is in the simple recovery model can I take a differential backup of it?” 

Read on for the answer to this, as well as a demonstration in fact of said answer. Kenneth also adds in bonus answers for free regarding msdb, model, and tempdb.