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

CreateDatabaseFromBackupCopy task

Creates a new database by restoring a backup of an existing tenant database.

Syntax 1 (SQL)
CALL DBCloud.CreateDatabaseFromBackupCopy ( backupcopy=backupcopy, database_name=database_name, server=server [, optional-parameters ] )
Syntax 2 (Cloud Command utility)
dbcloudcmd run CreateDatabaseFromBackupCopy backupcopy database_name server [ optional-parameters ]
Parameters
  • backupcopy

    The backup copy to restore. Accepts a backup copy name, ID, or a search query that identifies a single backup copy. (Required)

  • database_name

    The name of the new database. The name must be unique within the cloud. (Required)

  • server

    The target cloud server. Accepts a cloud server name, ID, or a search query that identifies a single cloud server. (Required)

  • include_latest_log

    Set to 1 to include the latest transaction log from the database. The default is 0.

  • database

    An output parameter. Internal use only.

Required privileges

RestoreDatabase, AddDatabase

Remarks

This task creates a new database by using a copy of either a full or incremental backup.

All relevant backup files are copied to the host where the specified cloud server is running, and the new database is created and started on that cloud server.

The database that the backup belongs to is not modified.

This task is similar to the RestoreBackupCopy task. Both tasks restore a backup, but RestoreBackupCopy replaces the primary copy of the database whose backup it is restoring and requires that database be stopped. Restoring a backup is useful when a database has become corrupted or data has been lost, and you want to restore the database to a previous state. CreateDatabaseFromBackupCopy does not require the database to be stopped and creates a new database that is an exact copy of the original database at the time of the specified backup. This task can be used to create a temporary copy of a database that can be modified without affecting the existing database.

The backupcopy parameter accepts a backup copy ID. To view a list of all backup copy IDs in the cloud, run the following:

dbcloudcmd describe type:backupcopy

The following search restricts the list of backup copy IDs:

dbcloudcmd describe "type:backupcopy and host:myhost and creation_time > '2012-05-02T14:20:00-04:00'"

Example

Run the following task to restore the backup copy with the ID BC-q5v5 and start it on the cloud server my-server#3 as the database with the name myDBnew:

dbcloudcmd run CreateDatabaseFromBackupCopy backupcopy=BC-q5v5 database_name=myDBnew server=my-server#3