Home / Commands / Invoke-sqmDistributedFailover
Invoke-sqmDistributedFailover
Distributed sqmSQLTool v1.8.2+
Initiates failover of a Distributed AlwaysOn AG.

Examples

Invoke-sqmDistributedFailover -SqlInstance "SQL01" -AvailabilityGroupName "MyDAG" -Force
Invoke-sqmDistributedFailover -SqlInstance "SQL01" -AvailabilityGroupName "MyDAG" -Force
Invoke-sqmDistributedFailover -SqlInstance "SQL01" -AvailabilityGroupName "MyDAG" -WhatIf
Invoke-sqmDistributedFailover -SqlInstance "SQL01" -AvailabilityGroupName "MyDAG" -WhatIf
# Rollback zum alten System nach fehlgeschlagenem Failover:
# Rollback zum alten System nach fehlgeschlagenem Failover:
    Invoke-sqmDistributedFailover -SqlInstance "SQL01" -AvailabilityGroupName "MyDAG" -Rollback -Force
← Previous Command
Get-sqmDistributedAgHealth
Next Command →
New-sqmDistributedAvailabilityGroup