YoVDO

Log Shipping in SQL Server - High Availability and Disaster Recovery

Offered By: PASS Data Community Summit via YouTube

Tags

PASS Data Community Summit Courses Disaster Recovery Courses Database Administration Courses High Availability Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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 Professional
PASS 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