Mirror server dropping

You can use a DROP MIRROR SERVER statement to drop mirror servers. It is recommended that you do not drop a mirror server that is running as part of a database mirroring system.

When you set up a database mirroring system, mirror servers that are eligible to become the primary server have two definitions (CREATE MIRROR SERVER...AS PARTNER and CREATE MIRROR SERVER...AS PRIMARY or CREATE MIRROR SERVER...AS MIRROR). You may need to drop both the role and partner server definitions from the database, depending on your reason for dropping the mirror server.

Note

If you want to keep the same mirror server name but change its settings, you can use the CREATE OR REPLACE MIRROR SERVER statement or the ALTER MIRROR SERVER statement. See CREATE MIRROR SERVER statement and ALTER MIRROR SERVER statement.

 Drop a mirror server (SQL)

It is recommended that you do not drop a mirror server that is running as part of a database mirroring system.

  1. Connect to the database as a user with DBA authority.

  2. Execute a DROP MIRROR SERVER statement to drop the mirror server. For example:

    DROP MIRROR SERVER mirror-server-name;
 See also
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1