Backup & Recovery from First Principles, Part 2: Anatomy of a Backup

· by · in

A backup file is not a copy of your MDF. It is a container with a precise contract: enough pages and enough log to reconstruct a transactionally consistent database as of the moment the backup…