HP XP7 Replication Manager Application Agent CLI User Guide (TK981-96015, May 2014)

Figure 20 Example of a multi-target configuration (when the backup is of an SQL Server database)
Requirements and precautions for backing up SQL Server
databases
The table below describes the types of data subject to backup in the SQL Server database. Backed-up
databases differ depending on option specifications in the backup command (the drmsqlbackup
or EX_DRM_SQL_BACKUP command).
Table 1 Types of data subject to backup in the SQL Server database
Storage destination for
backup files
Backup file name
Type of file subject to
backup
Database subject
to backup
#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
Meta file
#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
Varies depending on the VDI metafile storage directory
specified with the -drmsqlinit command
#3
Meta file
#2
Secondary volume
Same as the backup source
file name
Data file
msdb
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
Meta file
#2
Application Agent CLI User Guide 51