skills.rest
rudi-bruchez
rudi-bruchezCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

sqlserver-high-availability

Manage and monitor SQL Server high availability and disaster recovery solutions.

Updated Feb 19, 2026
Search Tags:#disaster recovery#high availability#failover#sql server#database administration#always on#log shipping
One-click install
npx skills add https://github.com/rudi-bruchez/dba-skills --skill sqlserver-high-availability
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sqlserver-high-availability
Source: https://github.com/rudi-bruchez/dba-skills/tree/main/skills/sqlserver-high-availability
Command: npx skills add https://github.com/rudi-bruchez/dba-skills --skill sqlserver-high-availability

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) and assets (resource) components.

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.

Frequently Asked Questions about sqlserver-high-availability

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I configure Always On Availability Groups for SQL Server high availability?▼

To configure Always On Availability Groups for SQL Server high availability, this Skill provides setup guidance for AGs, Failover Cluster Instances, and Log Shipping to ensure database resilience and minimize downtime across SQL Server 2016 and later versions.

What is the best way to monitor SQL Server failover and replica synchronization health?▼

The best way to monitor SQL Server failover and replica synchronization health is through provided health check queries that assess replica status, synchronization lag, listener status, and log shipping jobs to ensure continuous database availability.

Does this support forced failover procedures for SQL Server disaster recovery?▼

Yes, disaster recovery support includes decision trees and commands for performing planned and forced failovers, as well as failback procedures, ensuring database resilience and minimizing data loss during primary server failures.

When do I need log shipping versus Always On Availability Groups for database resilience?▼

You need log shipping versus Always On Availability Groups depending on your database resilience requirements; this Skill manages both solutions, offering configuration guidance and monitoring to ensure continuous data protection and availability in SQL Server environments.

Can I use this to troubleshoot synchronization lag in SQL Server Availability Groups?▼

Yes, you can use this to troubleshoot synchronization lag in SQL Server Availability Groups by running the provided health check queries that monitor replica health, listener status, and synchronization performance to maintain uptime.

Related Skills

Explore More Software Engineering Skills→
chrishuffman5chrishuffman5

sqlserver-ha-clustering

Automate SQL Server high availability and clustering configurations.

Community
Advanced
slantviewslantview
1

database-admin

Manage PostgreSQL database setup, backups, replication, monitoring, and user permissions.

Community
Advanced
larsnyglarsnyg

sql-server-admin

Automate SQL Server administration tasks including backups, security, and maintenance.

Community
Advanced
nicolasmosquerarnicolasmosquerar
1

Disaster Recovery Blueprints

Orchestrate multi-region disaster recovery with automated failover and cross-region replication.

Community
Advanced