HP Serveur lame HP ProLiant BL465c Gen8 - Manual (Page 51)

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