ALTER REPLICATION GROUP or ALTER FAILOVER GROUP with SUSPEND IMMEDIATE clause: Synchronously cancel active replication job (Preview)¶

The SUSPEND IMMEDIATE clause of the ALTER REPLICATION GROUP command or ALTER FAILOVER GROUP command behaves as follows:

Before the change:

The ALTER { REPLICATION | FAILOVER GROUP } name SUSPEND IMMEDIATE command begins to cancel the ongoing refresh job but returns immediately, regardless of whether the refresh job is canceled yet.

After the change:

The ALTER { REPLICATION | FAILOVER GROUP } name SUSPEND IMMEDIATE command waits and returns only after the refresh job has been successfully canceled.

This behavior change is being made to provide more predictable and deterministic behavior for the command. The change removes the need for you to manually verify when the refresh job is fully canceled.

Ref: 2202