Show TOC

abort switchLocate this document in the navigation structure

Aborts the switch active command, unless Replication Server has gone too far in the active switch process to abort it. The switch active command changes the active database in a warm standby application.

Syntax
abort switch for <logical_ds>.<logical_db>
Parameters
logical_ds

The data server name for the logical connection.

logical_db

The database name for the logical connection.

Examples
Example 1

Replication Server has gone too far in the active switch process to cancel. Wait for the switch to complete and enter another switch active command to return to the original active database.

abort switch for LDS.pubs2
Switch for logical connection LDS.pubs2 is beyond the
point where it can be aborted. Abort command fails.
Example 2

Replication Server has aborted the active switch. The active database has not changed.

abort switch for LDS.pubs2
Switch for logical connection LDS.pubs2 has been aborted.
Usage
  • The abort switch command attempts to cancel the switch active command.

  • If there is no switch in progress for the logical connection, Replication Server returns an error message.

  • If the command cancels the active switch successfully, you may have to restart the RepAgent for the active database.

  • The switch active command cannot be cancelled after it reaches a certain point. If this is the case, you must wait for the switch active to complete. Then use switch active again to return to the original active database.

Permissions

abort switch requires "sa" permissions.