Log Shipping in SQL Server - High Availability and Disaster Recovery
Offered By: PASS Data Community Summit via YouTube
Course Description
Overview
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.
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
Doing More with Less - The Challenges Ahead for Every Data ProfessionalPASS Data Community Summit via YouTube Build a Modern Data Strategy and Put Your Data to Work
PASS Data Community Summit via YouTube Transform Your Data Estate
PASS Data Community Summit via YouTube Azure SQL and SQL Server 2022 - Intelligent Database Futures
PASS Data Community Summit via YouTube SQL Server in Azure Virtual Machines Reimagined
PASS Data Community Summit via YouTube