Break five common myths about SQL Server backup
summary
80 people are interviewed and 70–75% get these wrong; demos show concrete results: a full backup doesn't break log chain so restoring a later log after an intervening full or differential recovers all rows; only the last differential is needed plus the right log(s); tempdb cannot be backed up and master/model/msdb behave differently for recovery models; taking transaction log backups during a full backup is optional to reach the full backup point; backups don't use 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
47mDisaster Recovery Strategies for SQL Server
21mSQL Server 2022 – Time to Rethink your Backup and Recovery Strategy- 21mSQL Server 2022 – Time to Rethink your Backup and Recovery Strategy
- 47mDisaster Recovery Strategies for SQL Server
29mYou Don't Need a Database Backup Policy
49mEverything you always wanted to know about HA/DR for SQL Server on Azure VMs but were afraid to ask
38mProtecting Database Backups From Ransomware and Malicious Intent