Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Disaster Recovery Strategies for SQL Server

SQLBits via YouTube

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Explore disaster recovery strategies for SQL Server in this 47-minute conference talk by Microsoft Data Platform MVP Andrew Pruski. Learn critical aspects of managing SQL Server, including planning for worst-case scenarios, available technologies, and implementing recovery strategies during crises. Discover the differences between high availability and disaster recovery, understand recovery objectives, and delve into various techniques such as backup and restore, mirroring, and availability groups. Gain insights on monitoring, alerting, enacting disaster recovery plans, and conducting tests. Explore additional implementations and experiments to enhance your SQL Server disaster recovery knowledge.

Syllabus

Introduction
About me
Agenda
Hope is not a strategy
Top 3 DBA tasks
High availability vs Disaster Recovery
Recovery Objectives
Backup and Restore
Mirroring
Availability Groups
Distributed AGS
Monitoring Alerting
Enact Dr
Dr Testing
Other implementations
Experiments

Taught by

SQLBits

Reviews

Start your review of Disaster Recovery Strategies for SQL Server

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.