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.
There are no prerequisites for performing this task.
Context and remarks
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.
Connect to the database as a user with DBA authority.
Execute a DROP MIRROR SERVER statement to drop the mirror server. For example:
The following statement drops a mirror server named mymirror1:
DROP MIRROR SERVER mymirror1;
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|