HP StorageWorks P9000 Replication Manager Software 7.1.1 CLI User Guide (TB584-96032, September 2011)

Requirements and precautions when 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 3 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
Secondary volume
Same as the backup source
file name
Data file
User database
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
Distribution database
Secondary volume
Same as the backup source
file name
Transaction log file
Depends on the VDI metafile storage directory specified
in the -drmsqlinit command
#3
Metafile
#2
#1
When the -system option is not specified, only user databases are backed up.
Application Agent CLI User Guide 77