AG

Suspend-DbaAgDbDataMovement

Chrissy LeMaire (@cl), netnerds.net

Suspend-DbaAgDbDataMovement View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Suspends data synchronization for availability group databases to halt replication between replicas. Description Temporarily halts data movement between primary and secondary replicas for specified availability group databases. This stops transaction log records from being sent to secondary replicas, which is useful during maintenance windows, troubleshooting synchronization issues, or when preparing for manual failovers. While suspended, the secondary databases will fall behind the primary and cannot be failed over to until data movement is resumed.

Sync-DbaAvailabilityGroup

Chrissy LeMaire (@cl), netnerds.net

Sync-DbaAvailabilityGroup View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Synchronizes server-level objects from primary to secondary replicas in availability groups Description Copies server-level objects from the primary replica to all secondary replicas in an availability group. Availability groups only synchronize databases, not the server-level dependencies that applications need to function properly after failover. This command ensures that logins, SQL Agent jobs, linked servers, and other critical server objects exist on all replicas so your applications work seamlessly regardless of which replica becomes primary.

Test-DbaAgSpn

Chrissy LeMaire (@cl), netnerds.net

Test-DbaAgSpn View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Validates Service Principal Name registration for Availability Group listeners in Active Directory Description Checks whether the required SPNs are properly registered in Active Directory for each Availability Group listener’s service account. This function queries AD to verify that both the MSSQLSvc/listener.domain.com and MSSQLSvc/listener.domain.com:port SPNs exist, which are essential for Kerberos authentication to work correctly with AG listeners. Use this to troubleshoot client connectivity issues, validate SPN configuration before deployments, or audit security compliance.

Test-DbaAvailabilityGroup

Andreas Jordan (@JordanOrdix), ordix.de

Test-DbaAvailabilityGroup View Source Andreas Jordan (@JordanOrdix), ordix.de Windows, Linux, macOS 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. When used with the AddDatabase parameter, performs comprehensive prerequisite validation before adding databases to an AG.

← Previous

1 2 3 4

Page 4 of 4