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 (dbcloudcmd)

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. Run the ConvertMirrorToScaleOutDatabaseCopy task on the mirror database.
  2. Once the mirror has been converted back to a scale-out database copy, run the StopDatabaseCopy task.
  3. Run the DropScaleOutDatabaseCopy task to drop the old mirror.
  4. Run the SetArbiter task with the parameter set to NULL.

Results

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