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

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
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.
#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:
\ / : , ; * ? < > |
Application Agent system configurations 52