SQLBits 2023

Break five common myths about SQL Server backup

In this session, I will discuss five common myths about SQL Server backup and demo each to show you the correct answer.
In this session, I will discuss five common myths about SQL Server backup and demo each to show you the correct answer.

1. Does Full and Differential backup breaks the log chain?
2. Are Differential backups incremental?
3. What backups are allowed on system databases?
4 Is transactional backup necessary during full backup?
5. Does backup use a buffer pool to read data pages?