sqlserver-high-availability
CommunityEnsure SQL Server uptime and resilience.
Software Engineering#disaster recovery#high availability#failover#sql server#database administration#always on#log shipping
Authorrudi-bruchez
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill addresses the critical need for continuous database availability and data protection in SQL Server environments by implementing and managing high availability (HA) and disaster recovery (DR) solutions.
Core Features & Use Cases
- HA/DR Configuration: Set up Always On Availability Groups (AGs), Failover Cluster Instances (FCIs), and Log Shipping.
- Monitoring & Troubleshooting: Provides queries and guidance for checking replica health, synchronization lag, listener status, and log shipping jobs.
- Failover Management: Offers decision trees and commands for performing planned and forced failovers, as well as failback procedures.
- Use Case: An organization needs to ensure their critical customer database remains accessible even if the primary server fails. This Skill guides the setup of an Always On Availability Group with automatic failover, minimizing downtime and data loss.
Quick Start
Use the sqlserver-high-availability skill to check the health of your Always On Availability Group.
Dependency Matrix
Required Modules
None requiredComponents
scriptsreferencesassets
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: sqlserver-high-availability Download link: https://github.com/rudi-bruchez/dba-skills/archive/main.zip#sqlserver-high-availability Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.