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

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
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.
#2
This file is created when the backup command executes.
#3
When a VDI metafile storage directory was registered by using the drmsqlinit command, the
metafile is stored in the registered directory. The file name is backup-ID_database-ID.dmp. When
a VDI metafile storage directory was not registered by using the drmsqlinit command, the
metafile is stored in the directory that contains the file whose management number (file_id)
for SQL Server in the database file is a minimum value. The file name is META_database-ID.dmp.
In Application Agent, data is backed up and restored in physical volumes units so the object
configuration of an SQL Server database requires the following:
• Configure the database configuration files that comprise one instance on one physical volume.
Do not store database configuration files that comprise multiple instances on one physical volume.
• Store the following directory and file on a physical volume that does not contain database config-
uration files (*.mdf, *.ndf, and *.ldf):
• Metafile storage directory (except when metafile setting is blank)
• Backup data of the transaction log
Roll-forward recovery processing can be performed if the above directory and file are placed on
separate volumes. This is because, even if a restoration is performed, the metadata and transaction
log file cannot return to the status they were in when the backup was performed.
Backup processing for Application Agent checks whether these requirements are satisfied. If they
are not satisfied, backup processing will terminate with an error.
• You can use the following characters when naming a database:
• ASCII characters
• Multi-byte characters (one character must be expressed by using 1 or 2 bytes)
However, do not use the following characters:
\ / : , ; * ? < > |
• Do not use the name META_database-ID (ten digits).dmp for a data file of a database or transaction
log file.
• In a cluster environment, specify a user on each node for the owner of a database subject to
backup. Local users with the same user name and password on different nodes are not considered
to be the same user. Therefore, use a domain user account that is common to all nodes. If failover
is performed to a node where the database-owner user does not exist, backup fails because the
database owner is unknown.
• Backed-up data cannot be restored or recovered by specifying the -undo option during execution
of the drmsqlinit command when there is no registered directory for storing the UNDO file.
Application Agent system configurations84