AvailabilityGroup

Compare-DbaAgReplicaAgentJob

dbatools team

Compare-DbaAgReplicaAgentJob View Source dbatools team Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Compares SQL Agent Jobs across Availability Group replicas to identify configuration differences. Description Compares SQL Agent Jobs across all replicas in an Availability Group to identify differences in job configurations. This helps ensure consistency across AG replicas and detect when jobs have been modified on one replica but not others.

Compare-DbaAgReplicaCredential

dbatools team

Compare-DbaAgReplicaCredential View Source dbatools team Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Compares SQL Server Credentials across Availability Group replicas to identify configuration differences. Description Compares SQL Server Credentials across all replicas in an Availability Group to identify differences in credential configurations. This helps ensure consistency across AG replicas and detect when credentials have been created or removed on one replica but not others.

Compare-DbaAgReplicaLogin

dbatools team

Compare-DbaAgReplicaLogin View Source dbatools team Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Compares SQL Server logins across Availability Group replicas to identify configuration differences. Description Compares SQL Server logins across all replicas in an Availability Group to identify differences in login configurations. This helps ensure consistency across AG replicas and detect when logins have been created, modified, or removed on one replica but not others.

Compare-DbaAgReplicaOperator

dbatools team

Compare-DbaAgReplicaOperator View Source dbatools team Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Compares SQL Agent Operators across Availability Group replicas to identify configuration differences. Description Compares SQL Agent Operators across all replicas in an Availability Group to identify differences in operator configurations. This helps ensure consistency across AG replicas and detect when operators have been created or removed on one replica but not others.

Compare-DbaAgReplicaSync

the dbatools team + Claude

Compare-DbaAgReplicaSync View Source the dbatools team + Claude Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Compares server-level objects across Availability Group replicas to identify synchronization differences. Description Compares server-level objects across all replicas in an Availability Group to identify differences that would prevent seamless failover. Availability groups only synchronize databases, not the server-level dependencies that applications need to function properly after failover.

Compare-DbaAvailabilityGroup

dbatools team

Compare-DbaAvailabilityGroup View Source dbatools team Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Compares configuration across Availability Group replicas to identify differences in Jobs, Logins, Credentials, and Operators. Description Compares multiple object types across all replicas in an Availability Group to identify configuration differences. This comprehensive command checks SQL Agent Jobs, SQL Server Logins, SQL Server Credentials, and SQL Agent Operators to ensure consistency across AG replicas.

Test-DbaAvailabilityGroup

Andreas Jordan (@JordanOrdix), ordix.de

Test-DbaAvailabilityGroup View Source Andreas Jordan (@JordanOrdix), ordix.de Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Validates Availability Group replica connectivity and database prerequisites for AG operations Description Verifies that all replicas in an Availability Group are connected and communicating properly by checking ConnectionState across all replicas from the primary’s perspective. This helps you identify connectivity issues that could impact failover capabilities or data synchronization.