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?
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?