Proving the Restore, Part 13: Two Vocabularies for the Same Backup
This series has used two sources for the same information. msdb records what the instance did. RESTORE HEADERONLY reads what’s in the files. They describe the same backups and disagree on almost every name. Code…
Proving the Restore, Part 7: One File, Hundreds of Backup Sets
Point RESTORE HEADERONLY at a full backup and you get one row. Point it at the file a fifteen-minute log backup job has been appending to since Sunday and you get several hundred. Each row…
Proving the Restore, Part 2: HEADERONLY Changes Shape Between Versions
In I used msdb to find a database whose newest full backup had aged past a week. msdb tells you a backup happened. It doesn’t tell you the file is still readable, or which database…