Explore the fundamentals and practical applications of log shipping in SQL Server through this comprehensive conference talk. Delve into transaction log, backup, and restore essentials before witnessing a live demonstration of setting up log shipping using the wizard. Discover various scenarios where log shipping can be employed for High Availability (HA) and Disaster Recovery (DR). Learn how to manually configure and run customized log shipping solutions, and explore its potential for server migration, version upgrades, and transitioning to Availability Groups. Gain valuable insights into when and how to leverage log shipping to meet your business needs, complete with practical demonstrations and comparisons to other SQL Server features like Database Mirroring and Availability Groups.
Log Shipping in SQL Server - High Availability and Disaster Recovery
PASS Data Community Summit via YouTube
Overview
Syllabus
Intro
PASS Summit 2019
Upcoming Virtual Group Webinars
PASS Virtual Groups
PASS Career Center
Connect with PASS
Log Shipping Overview
Database and Transaction Log
Transaction Log Operation
Write-ahead Example
Backup and Restore
Backup/Restore Demo
Log Shipping Features in SQL Server
What can I use log shipping for? (1 of 3)
What can I use log shipping for? (2 of 3)
Log Shipping vs. DBM vs. AG
Log Shipping - Custom Feature - Why?
Taught by
PASS Data Community Summit
Related Courses
-
Log Shipping in SQL Server
-
SQL Server: Advanced Corruption Recovery Techniques
-
Architect migration, business continuity, and disaster recovery in Azure
-
HA - DR in SQL Server - Putting the Puzzle Pieces Together and Planning for the Future
-
High Availability - Disaster Recovery 101
-
High Availability - Disaster Recovery 101 - Data Architecture
