HP XP7 Replication Manager Application Agent CLI Reference Guide (TK981-96014, May 2014)

appears, indicating that no parameters are set for the drmsqlinit command. Specify the UNDO
file storage directory using the drmsqlinit command.
When this option is omitted, a regular restoration is performed. In this case, the database will be
placed in loading status after the restoration has finished, and will not be usable.
-nochk_host
Specify this option to restore the data to a host other than the one specified in the drmsqlbackup
command. This option is useful when the host name has been changed, or when the log distribution
function in SQL Server is used.
This option is not available when you restore a system database (master, model, msdb, or distribution).
NOTE:
When you specify the -nochk_host option, confirm that backup data is restored on the appropriate
host, because the validity of the host name in the backup catalog is not checked when restoring backup
data.
-instance name-of-the-SQL-Server-instance
Specify this option to restore the data to a SQL Server instance that is different from the SQL Server
instance on which you executed the drmsqlbackup command. If you specify DEFAULT as the SQL
Server instance name, you will be connected to the preset instance of the SQL Server. If the restoration
targets include a system database (master, model, msdb, or distribution), you cannot specify this
option.
-target database-names
Specify this option to restore a particular database in the specified instance. The specified database
needs to exist in the backup catalog specified by the backup ID. When databases that do not exist
in the backup catalog are specified, those databases will not be restored. When specifying multiple
databases to be restored at the same time, use a comma to separate each database name. If you
specify a database name containing a space character, enclose the database name in double quotation
marks (").
When both this option and the -f option are omitted, the entire instance specified by the backup ID
will be restored.
-f target-definition-file-name
Like the -target option, this option restores an instance containing specific databases. Unlike the
-target option, this option lets you specify a target definition file that collectively specifies all the
databases to be restored. The target definition file containing the list of databases must be created
before you attempt to use this option. Use an absolute path to specify the target definition file. If you
specify a target definition file name containing a space character, enclose the target definition file
name in double quotation marks (").
When both this option and the -target option are omitted, all the objects included in the instance
specified by the backup ID will be restored.
-no_resync
Specify this option to apply only the metafiles for the data on the primary volume, without performing
restoration processing or backing up data from the secondary volume to the primary volume. Use this
option when the restore operation cannot be performed with the drmsqlrestore command (for
example, when restoring backup data directly from a tape device to the primary volume because of
a drive failure).
Basic commands182