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.
What you'll learn
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.
Table of contents
- Introduction 1m
- Simple Recovery Model 3m
- Full Recovery Model 2m
- Point in Time Restores 6m
- Bulk Logged Recovery 3m
- Maintenance Plans 3m
- Managing Backups 3m
- Disaster Recovery from Backup 2m
- Log Shipping Wizard 4m
- Log Shipping by Script 3m
- Custom Log Shipping Approach 2m
- Custom Log Shipping Demo 4m
- Summary 2m
- Intro 5m
- Failover Cluster Concept 6m
- Clustering Prerequisites 4m
- More Clustering Prerequisites 4m
- Building Cluster Environment 4m
- Validating and Installing Failover Cluster 5m
- Preparing SQL Server Nodes 4m
- Completing SQL Server Cluster Installation 5m
- Testing Manual and Induced Failover 4m
- Active Passive vs. Active Active Concepts 3m
- Troubleshooting 6m
- Key Concepts and Summary 5m
- Key Concepts and Additional Resources 5m
- Intro 4m
- Terminology 5m
- AlwaysOn AG Protection 4m
- AbacosWidgets Business Case 3m
- Installing and Configuring AlwaysOn 5m
- Availability Group Setup, Joining Replicas, and Databases 7m
- Failover Modes and Manual Failover 5m
- Creating a Listener 3m
- Automatic Failover and Read Only Secondary 4m
- Adding Another Database 2m
- Offloading Database Backups 3m
- Configuring Quorum and Adding a Node 4m
- Monitoring AlwaysOn AG 3m
- Troubleshooting AlwaysOn AG 4m
- Additional AlwaysOn AG Considerations 6m
- AlwaysOn AG in SQL Server 2016 3m
About the author
Currently an IT leader in Denver Colorado's FinTech sector Russ has focused on database engineering, modelling, administration, and BI since 1997. Russ is a passionate trainer and community volunteer presenting regularly at tech events and local user groups around the US. In 2019 much of Russ' focus turned to cloud based data lakes specifically on Google BigQuery, and the emerging world of large language models.