DROP MIRROR SERVER  mirror-server-name

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.

You must have the MANAGE ANY MIRROR SERVER system privilege.

Automatic commit.

• Database mirroring
• CREATE MIRROR SERVER statement
• ALTER MIRROR SERVER statement
• COMMENT statement

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";