View Event: Break five common myths about SQL Server backup
Track: Database Management
Level: 200This talk is part of Lightning Talk
In this session, I will discuss five common myths about SQL Server backup and demo each of them to show you the correct answer. 1. Does Full and Differential backup break the log chain? 2. Are Differential backups incremental? 3. What types of backups are allowed on system databases? 4. Is a transaction log backup necessary during full backup? 5. Does backup use a buffer pool to read data pages?
Goals: You will clearly understand the impact on the log chain while taking a full or differential backup. You will know what recovery models are allowed on system databases and what kind of backups are allowed on each one. The demo will show how transactional backup behaves differently during a full backup, which will help you determine if you should be taking transactional backup during a full backup.
Prerequisites: Know the definition of full, differential, and transaction log backup for SQL Server.
Leave a Reply