Break five common myths about SQL Server backup
summary
Five concrete myths get busted with live T-SQL demos and numbers: repeated full backup does not break log chain — restoring the last log after a later full recovers all rows; differential needs only latest — you can skip intermediate diffs and restore the final diff plus required logs; system DB quirks: master accepts only full backups, model/msdb follow normal rules, and tempdb/10DB cannot be backed up; full backups include changes so concurrent log backups aren’t required to reach the full point; backups do not populate the regular buffer pool.
AI-written summary · about
chapters (6)
- 0:00Introduction and setup
- 1:34Full and differential backups
- 5:39Understanding incremental diffs
- 7:58System database backups
- 12:20Log truncation during backups
- 16:34Backup and buffer pool usage
related talks
18mBreak five common myths about SQL Server backup
21mSQL Horror Stories
21mSQL Server 2022 – Time to Rethink your Backup and Recovery Strategy
47mDisaster Recovery Strategies for SQL Server- 47mDisaster Recovery Strategies for SQL Server
48mSQL Server 2022 hidden gems
38mProtecting Database Backups From Ransomware and Malicious Intent
49mEverything you always wanted to know about HA/DR for SQL Server on Azure VMs but were afraid to ask