PASS Data Community Summit 2023

Date/Time: Friday November 17, 2023 1:30 PM
Location: Room 613, Seattle Convention Center, 705 Pike Street, Seattle, WA 98101-2310

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

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

profile for SqlWorldWide on Stack Exchange, a network of free, community-driven Q&A sites

Kubernetes Learning Path

50-days from zero to
hero with Kubernetes

Download eBook