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

SAP Sybase SQL Anywhere, on-demand edition 1.0 Support Package 3 » SAP Sybase SQL Anywhere, on-demand edition 1.0 » Tenant databases » Tenant database mirroring and read-only scale out systems

 

Stopping tenant database mirroring (dbcloudcmd)

Stop tenant database mirroring. This task removes the mirroring configuration from your tenant database.

Prerequisites

You must have the AlterTenantMirroring, DropDatabase, and StartStopDatabase privileges

Context and remarks

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.

 Task
  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.

 See also