User's Manual

7.6
Recovery Manager Commands
3PAR Recovery Manager 3.0.2 for Microsoft SQL Server User’s Guide
3PAR Confidential
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
-d parameter, 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).