Log Shipping for SQL Server

2022

TL; DR

This session covers the Log Shipping feature is SQL Server, how to configure it and monitor for best results.

Session Details

This session will cover the features and administration of log shipping in SQL Server. We will describe the basics of transaction logs, high availability and disaster recovery, and how log shipping can be used in those scenarios. We will demonstrate the Log Shipping Wizard, and also use the stored procedures to script a log shipping configuration. We will also demonstrate customized log shipping for scenarios where the built-in log shipping may not be adequate, such as log shipping from on-premises to cloud locations. We will also discuss how log shipping can be used to migrate to an Availability Group configuration, and other scenarios.

3 things you'll get out of this session

Rob Volk's other proposed sessions for 2026

DeepSQL: How To Discover SQL Server Internals - 2026

Revenge: The AI: Lightning Talk - 2026

Rob Volk's previous sessions

Thats So Metadata: Discover Your Database From the Inside

Learn about the metadata features in SQL Server that describe your database and how they can make documentation, tuning, and maintenance much easier.

Tame Your Unruly Data...With Constraints!

Is your data badly behaved and embarrassing you? Are you tired of cleaning up its messes? Constraints can help you straighten out your wayward data and put it on the right path before it gets into too much trouble.

Revenge: The SQL!

Are you a frustrated DBA? Ready to snap? Before you do, come see Revenge: The SQL! and learn a kinder, gentler form of vengeance.

Lego Sets: Relational Building Blocks

Introductory Relational Theory Using Lego Bricks to Model Data and Set Operations