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
Optimizing Microsoft Windows Server StorageMicrosoft via edX High Availability and Disaster Recovery with the SAP HANA Platform
SAP Learning Microsoft Exchange Server 2016 - 3: Mailbox Databases
Microsoft via edX Microsoft SharePoint 2016: Workload Optimization
Microsoft via edX Microsoft Azure Virtual Machines
Microsoft via edX