Practical SQL Server High Availability and Disaster Recovery

Supporting high availability and disaster recovery are without a doubt some of the most fundamental skill-sets necessary to being a successful senior level DBA. Whether you work in a multi-million dollar enterprise or a “strapped for cash” start-up, this course will compare and contrast the many features, techniques, and concepts available in SQL Server to meet your individual needs.
Course info
Rating
(101)
Level
Intermediate
Updated
Dec 30, 2015
Duration
4h 40m
Table of contents
Understanding High Availability vs. Disaster Recovery
Getting Familiar with the Transaction Log
Taking Backups and Implementing Log Shipping
Setting up Failover Clustering
Supporting Legacy Mirrors
Installing and Supporting AlwaysOn Availability Groups
Understanding Additional Approaches
Bringing It All Together
Description
Course info
Rating
(101)
Level
Intermediate
Updated
Dec 30, 2015
Duration
4h 40m
Description

Congratulations, you’re the DBA. Along with all the rights, privileges, and prestige that comes with that. It also means you are responsible for not only the uptime and guaranteed availability of your database servers but also the ability for any of those servers to quickly recovery from any disaster imaginable. Supporting these two areas are without a doubt some of the most fundamental skill-sets necessary to being a successful senior level DBA. This course will compare and contrast the many features, techniques, and concepts available in SQL Server that will meet your individual needs whether you work in a multi-million dollar enterprise or a “strapped for cash” start-up.

About the author
About the author

Currently an IT leader in Denver Colorado's financial sector Russ has focused on database development, modelling, administration, and BI since 1997 across the Microsoft stack. Russ is a passionate trainer and SQL community volunteer presenting regularly at PASS SQL Saturday events and local user groups around the US.

More from the author
More courses by Russ Thomas