HP StorageWorks P9000 Command View Advanced Edition Suite Software 7.0 Mainframe Agent Installation and Configuration Guide (TB581-96014, November 2010)

Storage destination for
backup files
Backup file name
File type of in-
terest
Database of in-
terest
#1
Secondary volume
Same as the backup source file
name
Data file
Distribution data-
base
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
#1:
If you do not specify the –system option, the database targeted for backup is the user database
only.
#2:
This file is created when the drmsqlbackup command is executed.
#3:
If you registered a VDI metafile storage directory by using the drmsqlinit command, the backup
file is stored in the registered directory. The file name is backup-ID_database-ID.dmp. If you did
not register a VDI metafile storage directory by using the drmsqlinit command, the backup
file is stored in the directory that contains the file with the smallest management number (file_id)
value for SQL Server in the database file. The file name is META_database-ID.dmp.
Arguments
instance-name
Specify the database instance to be backed up. If the instance to be backed up is the default, specify
DEFAULT.
-system
Specify this option to back up the system databases (master, model, and msdb), other than the
tempdb database, and all user databases. If this option is specified, SQL Server will be stopped
when the restoration is carried out.
-target database-name(s)
Specify this option to back up a particular database in the specified instance.
When specifying multiple databases to be backed up, use a comma to separate each database name.
If you specify a database name containing a space character, enclose the database name in double
quotation marks ("). Make sure that you specify the database in the instance instance-name. If you
specify databases in separate instances, those databases will not be backed up.
The database names specified in this option will be registered in the backup catalog, and can be
checked using the drmsqlcat command.
-f target-definition-file-name
Like the -target option, this option performs a backup related to specific databases only. Unlike
the -target option, this option lets you specify a target definition file that collectively specifies all
the databases for which a backup is to be performed. The target definition file containing the list of
databases must be created before you attempt to use this option. Use an absolute path name to specify
the target definition file. If you specify a target definition file name containing a space character,
enclose the target definition file name in double quotation marks (").
Basic commands144