skills.rest
chrishuffman5
chrishuffman5COMMUNITY
Explore all skills by this author →
GitHub

sqlserver-ha-clustering

Automate SQL Server high availability and clustering configurations.

Updated May 27, 2026
Search Tags:#disaster recovery#high availability#sql server#clustering#always on availability groups
One-click install
npx skills add https://github.com/chrishuffman5/sqlserver --skill sqlserver-ha-clustering
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sqlserver-ha-clustering
Source: https://github.com/chrishuffman5/sqlserver/tree/main/skills/sqlserver-ha-clustering
Command: npx skills add https://github.com/chrishuffman5/sqlserver --skill sqlserver-ha-clustering

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill provides in-depth knowledge and automation tools for SQL Server high availability and clustering, covering Always On Availability Groups, Failover Cluster Instances, and disaster recovery scenarios.

Core Features & Use Cases

  • Always On Availability Groups: Manage synchronous and asynchronous replication, listeners, seeding, and readable secondaries.
  • Failover Cluster Instances: Configure and troubleshoot FCI on Windows Server Failover Clustering.
  • Disaster Recovery: Plan and implement failover procedures, backup strategies, and data recovery scenarios.
  • Use Case: If you have a SQL Server environment with high availability requirements, this Skill will help you design, implement, and manage your high availability and disaster recovery solutions.

Quick Start

Run the 'scripts/01-ag-health.sql' script to check the health of your Always On Availability Groups.

Frequently Asked Questions about sqlserver-ha-clustering

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?▼

You can configure Always On Availability Groups using provided automation scripts to manage synchronous and asynchronous replication, listeners, automatic seeding, and readable secondary replicas for SQL Server high availability.

What is the difference between Failover Cluster Instances and Always On Availability Groups?▼

Failover Cluster Instances rely on Windows Server Failover Clustering for shared storage redundancy, whereas Always On Availability Groups replicate databases to independent secondary replicas for SQL Server high availability and disaster recovery.

Do I need SQL Server management tools to implement high availability and clustering?▼

Yes, you need SQL Server management tools and working knowledge of SQL Server DMVs and T-SQL to effectively run the health monitoring scripts and implement the high availability and clustering configurations.

How do I check the health of my SQL Server Availability Groups?▼

Run the provided '01-ag-health.sql' script to query SQL Server DMVs and instantly check the synchronization status, replica health, and overall operational state of your Always On Availability Groups.

What's the best way to plan disaster recovery for a SQL Server environment?▼

Plan disaster recovery by utilizing the Skill's resources to implement automated failover procedures, define comprehensive backup strategies, and simulate data recovery scenarios across your SQL Server high availability topology.

Why does my SQL Server Failover Cluster Instance not failover correctly?▼

Troubleshoot Failover Cluster Instance issues by reviewing Windows Server Failover Clustering configurations and utilizing provided scripts to identify underlying SQL Server clustering or storage connectivity problems.

Related Skills

Explore More Software Engineering Skills→
MassimilianoPiliMassimilianoPili

dba-mssql

Design and administer SQL Server 2022+ databases with T-SQL and performance tuning.

Community
Advanced
lapc506lapc506
4

Disaster Recovery & Business Continuity

Automate disaster recovery planning, backups, failover, and DR testing.

Community
Advanced
rudi-bruchezrudi-bruchez

sqlserver-high-availability

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

Community
Advanced
MovchanetsMovchanets

database-admin

Plan and validate database administration workflows for cloud and self-managed environments.

Community
Advanced