AG

Set-DbaAvailabilityGroup

Chrissy LeMaire (@cl), netnerds.net

Set-DbaAvailabilityGroup View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Modifies availability group configuration settings including DTC support, backup preferences, and failover conditions Description Modifies configuration properties of existing availability groups without requiring you to script out and recreate the entire AG setup. Commonly used to enable DTC support for distributed transactions, adjust automated backup preferences across replicas, configure failure condition levels for automatic failover, and set health check timeouts for monitoring.

Suspend-DbaAgDbDataMovement

Chrissy LeMaire (@cl), netnerds.net

Suspend-DbaAgDbDataMovement View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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.

Sync-DbaAvailabilityGroup

Chrissy LeMaire (@cl), netnerds.net

Sync-DbaAvailabilityGroup View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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.

Test-DbaAgSpn

Chrissy LeMaire (@cl), netnerds.net

Test-DbaAgSpn View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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.

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.

← Previous

1 2 3 4

Page 4 of 4