What if we did crazy things with log shipping, like using it for scale out reporting? And stick it behind a load balancer? For big monster terabyte-plus databases, it can work like a kind of pool of Always On readable secondaries.
You'll need a membership to access this course. Check out my training classes.
- 01. Choosing the Right HA/DR Features: Defining Your RPO and RTO (17m)
- 02. Choosing the Right HA/DR Features: Why Some Options Look So Expensive (12m)
- 03. Choosing the Right HA/DR Features: HA/DR Features Explained (23m)
- 04. Transaction Log Shipping: Log Shipping Overview (17m)
- 05. Transaction Log Shipping: Unplanned Failovers (16m)
- 06. Transaction Log Shipping: Planned Failovers (18m)
- 07. Transaction Log Shipping: Fixing a Lagging Log Shipping Secondary (9m)
- 08. Transaction Log Shipping: Log Shipping Gotchas and Tools (10m)
- 10. Database Mirroring: Why Database Mirroring is Still Your Friend (13m)
- 11. Database Mirroring: Database Mirroring Rescue Scenarios (12m)
- 12. Database Mirroring: Demo: Failing over a Mirror; Automatic Page Repair (20m)
- 13. Database Mirroring: Monitoring Database Mirroring (8m)
- 14. Database Mirroring: Learning Plan (5m)
- 15. Quorum for Clusters and AGs: What Quorum Is, Why it Matters, and How to Configure It (21m)
- 16. Quorum for Clusters and AGs: Dynamic Quorum and Dynamic Witness (23m)
- 17. Cluster Validation for Clusters and AGs: Demo (11m)
- 18. Failover Clustered Instances: Features, Requirements, and Licensing (20m)
- 19. Failover Clustered Instances: Demo – Failing Over (18m)
- 20. Failover Clustered Instances: Links to Free Online Labs, Install Instructions, Articles
- 21. Always On Availability Groups Planning: Introduction and Sample Deployments (16m)
- 22. AlwaysOn Availability Groups Planning: Horror Stories and Successes (19m)
- 23. AG Failure Triage: Welcome to Triaging AGs (5m)
- 24. AG Failure Triage: Demo: Tour the AG Before It Breaks (7m)
- 25. AG Failure Triage: Demo: Triaging the Broken AG (34m)
- 26. AG Failure Triage: Recap: Why Did Quorum Fail? (5m)
- 27. AG Failure Triage: How You Can Triage Failures in AGs (14m)
- 28. Real-Life Lessons Learned: Brent’s Bug-Out Bag (5m)
- 29. Real-Life Lessons Learned: Role Swap Lessons Learned (9m)