DROP MIRROR SERVER statement

Drops a mirror server.

Syntax

DROP MIRROR SERVER mirror-server-name

Remarks

Removes the specified mirror server definition from the database.

The mirror database stops. If the mirror database is the only database running on the server, then the server also stops.

Read-only scale-out and database mirroring each require a separate license.

Privileges

You must have the MANAGE ANY MIRROR SERVER system privilege.

Side effects

Automatic commit.

Standards

ANSI/ISO SQL Standard
Not in the standard.

Example

This example creates, and then drops, a mirror server named scaleout_primary2:

CREATE MIRROR SERVER "scaleout_primary2"
   AS PRIMARY
   connection_string = 'server=scaleout_primary1;host=winxp-2:6871,winxp-3:6872';
DROP MIRROR SERVER "scaleout_primary2";