Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP SQL Anywhere, on-demand edition 1.0 SP 6 » Tenant databases » Tenant database mirroring and read-only scale out systems

Stopping tenant database mirroring (Cloud Console)

Stop tenant database mirroring.

Prerequisites

You must have the AlterTenantMirroring, DropDatabase, and StartStopDatabase privileges

Context

Removing the mirroring configuration from a tenant database involves stopping and dropping the mirror so that the database no longer runs in a mirroring system.

If the tenant database has scale-out database copies, the read-only scale-out configuration is intact.

Procedure

  1. In the Cloud Console, navigate to the Mirror & Scale-out panel of the tenant database.
  2. Click Stop mirroring.

Results

The mirror database is deleted, and the read-write database that is running as the primary database is no longer involved in a mirroring system.

Example

The following commands stop tenant database mirroring.

dbcloudcmd -cc uid=dbtest;pwd=sql;host=h1 run ConvertMirrorToScaleOutDatabaseCopy asatest@h2#1
dbcloudcmd -cc uid=dbtest;pwd=sql;host=h1 run StopDatabaseCopy asatest@h2#1
dbcloudcmd -cc uid=dbtest;pwd=sql;host=h1 run DropScaleOutDatabaseCopy asatest@h2#1
dbcloudcmd -cc uid=dbtest;pwd=sql;host=h1 run SetArbiter asatest NULL