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
Emergency ManagementOpen2Study Resilience in Children Exposed to Trauma, Disaster and War: Global Perspectives
University of Minnesota via Coursera MongoDB Advanced Deployment and Operations
MongoDB University Arch403: Designing Resilient Schools
Build Academy via EdCast Bases de données relationnelles : Comprendre pour maîtriser
Inria (French Institute for Research in Computer Science and Automation) via France Université Numerique