HP XP P9000 Replication Manager Software 7.6.0-00 Application Agent CLI Reference Guide

If you specify an instance that is not running, the command fails. All the user databases included in
the instance are to be backed up. The system databases (master, model, and msdb) for SQL server
are not included. You can back up system databases in either of the following ways:
• Execute the command with the -system option specified.
• Execute the command by specifying system databases (master, model, and msdb) with the
-target or -f option.
To back up all system databases (master, model, and msdb) except tempdb and all user databases,
execute the command with the -system option specified. To back up only system databases
(master, model, and msdb), execute the command by specifying those databases with the -target
or -f option.
The system cache of the secondary volume must be cleared before executing this command. Mount
or unmount the secondary volume on the backup server to clear the system cache.
When you execute this command on the copy group in the paired status (PAIR), the status of the
copy group is changed to PSUS.
When the drmsqlbackup command is executed while the pair status is SMPL, paircreate is not
run automatically. Execute the paircreate command only when the PAIR_CREATE parameter of
the RAID Manager-linkage definition file (DEFAULT.dat) is set to ENABLE.
When the drmsqlbackup command is executed on the local site, and the pair status is SMPL, the
command does not automatically create a pair. In this case, if the PAIR_CREATE parameter in the
RAID Manager-linkage definition file (DEFAULT.dat) is set to ENABLE, the command automatically
creates a pair.
After installation, if the drmsqlbackup command is executed without executing the drmsqldisplay
command with the -refresh option specified, and no dictionary map files are created, dictionary
map files are created using the drmsqlbackup command. In this case, the processing time required
to create the dictionary map files is added to the time required to execute the backup command.
Therefore, before you execute the drmsqlbackup command, make sure to first execute the
drmsqldisplay command with the -refresh option specified to create the dictionary map files.
One execution of the command can back up a maximum of 64 databases. If you want to back up
65 or more databases, execute the command more than once.
Backups can only be performed for files described in the following table.
Table 37 Files for which SQL Server database backup can be performed
Storage destination for
backup files
Backup file name
File type of in-
terest
Database of in-
terest
#1
Secondary volume
Same as the backup source file
name
Data file
master
Secondary volume
Same as the backup source file
name
Transaction log file
Varies depending on the VDI metafile storage directory specified
with the -drmsqlinit command
#3
Metafile
#2
Secondary volume
Same as the backup source file
name
Data file
model
Secondary volume
Same as the backup source file
name
Transaction log file
Basic commands146