Home / Commands / Invoke-sqmFailover
Invoke-sqmFailover
AlwaysOn sqmSQLTool v1.8.2+
Performs a controlled AlwaysOn AG failover with pre- and post-checks.

Examples

Invoke-sqmFailover -SqlInstance "SQL01" -AvailabilityGroup "AG_Prod" -WhatIf
Invoke-sqmFailover -SqlInstance "SQL01" -AvailabilityGroup "AG_Prod" -WhatIf
Invoke-sqmFailover -SqlInstance "SQL01" -AvailabilityGroup "AG_Prod" `
Invoke-sqmFailover -SqlInstance "SQL01" -AvailabilityGroup "AG_Prod" `
        -TargetReplica "SQL02" -MaxRedoQueueMB 10
← Previous Command
Invoke-sqmAlwaysOnSetup
Next Command →
Invoke-sqmSqlAlwaysOnAutoseeding