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 » Task syntax

DropMirrorDefinitions task

Removes mirror server definitions from the specified databases.

Syntax 1 (SQL)
CALL DBCloud.DropMirrorDefinitions ( database_list=database_list )
Syntax 2 (Cloud Command utility)
dbcloudcmd run DropMirrorDefinitions database_list
Parameters
  • database_list

    A list of databases to drop mirror definitions from. Accepts a search query that identifies databases. The search query can be a list of database names or IDs separated by semicolons (;), or a full search. (Required)

Required privileges

AlterTenantMirroring

Remarks

This task drops any cloud server definitions related to mirroring or read-only scale-out. DropMirrorDefinitions can be run on a database that had a mirroring or read-only scale-out system, but currently has no mirror or scale-out database copies.

Example

Run the following task to drop mirror definitions from the databases called mytenant2 and demo1:

dbcloudcmd run DropMirrorDefinitions database_list=mytenant2;demo1