ENDDTAMIR - End mirroring

Use this command to end continuous or net change mirroring on a subscription.

Applies To—Source

Parameters

Table 1. Supported keywords
Keyword Description Choices Notes
TARGET Subscription name Name, generic*, *ALL Required
ENDTYP End type *CNTRLD, *IMMED Optional

Subscription name (TARGET)

Specifies the name of the subscription.

This is a required parameter.

Name
Specify the name of a subscription. This must be the same name defined in Management Console.
generic*
Generic names may be used for subscriptions, by adding an asterisk (*) after one or more characters that are common to the group of subscriptions names. For example, 'abc*' specifies all subscriptions starting with the characters 'abc'.
*ALL
Specifies all subscriptions.

End type (ENDTYP)

Specifies how you want to end replication.
*CNTRLD
Replication is ended when CDC Replication completes replication.
This is the default setting.
*IMMED
Mirroring is ended immediately.
Use this setting only if you cannot end data mirroring in a controlled manner.

Result

Messages are placed in the Event Log.

Examples

ENDDTAMIR TARGET(SUB1)

CDC Replication ends mirroring on source tables selected to subscription SUB1 in a controlled manner.

ENDDTAMIR TARGET(SUB1) ENDTYP(*IMMED)

CDC Replication ends mirroring on source tables selected to subscription SUB1 immediately.

ENDDTAMIR TARGET(*ALL) ENDTYP(*IMMED)

CDC Replication ends mirroring of source tables to all subscriptions immediately.