HP StorageWorks P9000 Replication Manager Software 7.1 CLI User Guide (TB584-96026, May 2011)

Requirements and precautions when backing up SQL Server databases
Application Agent supports the following SQL Server database products:
• SQL Server 2005 Enterprise Edition
• SQL Server 2005 Standard Edition
• SQL Server 2005 Workgroup Edition
• SQL Server 2008 Enterprise Edition
• SQL Server 2008 Standard Edition
• SQL Server 2008 Workgroup Edition
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 9 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
CLI User Guide 83