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

Udemy

SQL Server High Availability and Disaster Recovery (HA/DR)

via Udemy

Overview

Dive deep into how SQL Server works to implement an effective high availability and disaster recovery solution.

What you'll learn:
  • By the end of the course, attendees will be able to understand the different SQL Server high availability and disaster recovery technologies - how they work and properly implement the right solution to address recovery objectives and service level agreements

This is a deep dive course on understanding how SQL Server works to effectively choose the right high availability and disaster recovery solution that will address every organization's need to protect digital assets.


Packed with videos explaining concept and demos to reinforce the lessons, this course is what every IT professional needs to properly manage and protect a SQL Server database.


If you're a SQLServer database administrator or a systems administrator responsible for SQLServer databases, this is for you. You want to be well-informed and skilled in protecting SQLServer databases from unwanted data loss and outages. Because outages and data loss happen to databases. It's only a matter of time.


The course primarily uses SQLServer 2012 for demonstrations. But the concepts still apply to later versions of SQLServer on Windows - even SQLServer 2025 on Windows Server 2025.


OR...Just watch hours of Practical SQLServer HA/DRShow episode videos...FORFREE.


The goal of the Practical SQLServer HA/DRShow is to provide guidance and lessons beyond the technical know-how. It's the non-technical aspects of high availability and disaster recovery that most technology professionals often overlook but are as equally important nonetheless.


Get access to these videos without signing up on Udemy. Just expand the section Practical SQLServer HA/DRShow to watch the videos.

Syllabus

  • Introduction
  • Non-Technology Aspects of High Availability and Disaster Recovery
  • SQL Server Recovery Models
  • SQL Server Database Backups
  • SQL Server Transaction Log Internals
  • SQL Server Database Restore and Recovery
  • SQL Server System Databases
  • SQL Server Database Mirroring
  • SQL Server Log Shipping
  • SQL Server Failover Clustering
  • SQL Server Availability Groups
  • SQL Server Replication
  • Practical SQL Server HA/DR Show

Taught by

Edwin M Sarmiento

Reviews

4.7 rating at Udemy based on 1701 ratings

Start your review of SQL Server High Availability and Disaster Recovery (HA/DR)

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.