Practical SQL Server High Availability and Disaster Recovery
Pluralsight
Course Summary
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 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.
-
+
Course Syllabus
Understanding High Availability vs. Disaster Recovery- 11m 18s
—Introduction 2m 7s
—High Availability 2m 19s
—Disaster Recovery 3m 7s
—Policy 3m 44sGetting Familiar with the Transaction Log- 19m 24s
—Introduction 1m 44s
—ACID Transactions 6m 0s
—SQL Server Data Storage 2m 50s
—Transaction Log Operation 3m 39s
—Transaction Log Storage 3m 14s
—Summary 1m 55sTaking Backups and Implementing Log Shipping- 39m 18sSetting up Failover Clustering- 59m 22sSupporting Legacy Mirrors- 36m 58sInstalling and Supporting AlwaysOn Availability Groups- 1h 4mUnderstanding Additional Approaches- 34m 57sBringing It All Together- 14m 36s
