Dropping servers from 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.

Prerequisites

There are no prerequisites for performing this task.

Context and remarks

Many.

Drop a mirror server (SQL)

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.

Connect to the database as a user with DBA authority.
Execute a DROP MIRROR SERVER statement to drop the mirror server. For example:

Results

The mirror server is removed from the read-only scale-out system and its definition is removed from the database.

Next

None.

Example

The following statement drops a mirror server named mymirror1:

DROP MIRROR SERVER mymirror1;