Dropping servers from a scale-out system

You can use a DROP MIRROR SERVER statement to drop servers in a read-only scale-out system.

When you set up a scale-out system, the root database server may have two definitions (CREATE MIRROR SERVER ... AS PARTNER and CREATE MIRROR SERVER ... AS PRIMARY). You may need to drop both the role and partner server definitions from the database, depending on your reason for dropping the root server.

Note

If you want to keep the same 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.

 To drop a mirror server (SQL)

  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 © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0