COMMAND
RMSql create
SYNTAX
RMSql create -s <SQL Server> [-rc <target server> [-w <waittime>]] [-i <SQL instance>] [-d <database>]
DESCRIPTION
The RMSql create command creates a virtual copy of a SQL database or databases under an instance on the primary host where the SQL server instance is running. The virtual copy can be mounted to a host later for off-host processing. The RMSql create command also allows the user to create a synchronization to a Remote Copy group in periodic mode where a single SQL database or all of the SQL databases under an instance are defined, and create another virtual copy at the secondary site as a backup. As with Recovery Manager for SQL Server, this command only supports the online backup of an entire SQL database. Therefore, you must make sure the database is online before continuing with the virtual copy creation.
PARAMETERS
The following options are supported:
◆-s <SQL Server> - SQL server to which the database belongs.
Optional: uses the current server name as the default.
◆-i <SQL instance> - SQL server instance for which database belongs.
Optional: Uses MSSQLSERVER as the default if not specified.
◆-d <database> - The database from which to create a virtual copy.
Optional: Without the -dparameter, the instance level of virtual copy is used.
◆-w <waittime> - Wait time unit in seconds. By default, the wait time is 120 seconds. This wait time is only used by the Recovery Manager service to poll the status of the remote copy before creating a virtual copy at the secondary site.
◆-rc <target server> - For the Remote Copy Service, a Recovery Manager SQL server with Recovery Manager Backup component installed must be located at the secondary site.
EXAMPLES
The following command will create a snapshot for the database test on SQL server (SQLServer).
Recovery Manager Commands
