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

4. Back up the SQL Server's metafile created at the backup to the temporary folder.
Back up the SQL Server's metafile created at the backup to the temporary folder for extended
commands that is on the database server so that the SQL Server's metafile and temporary files
can be transmitted collectively to the backup server. To back up the SQL Server's metafile, execute
EX_DRM_SQLFILE_PACK.
DBServer > EX_DRM_SQLFILE_PACK Operation_A
After EX_DRM_SQLFILE_PACK is executed, an a backup-ID_database-ID.dmp file is created in
the temporary folder for extended commands, on the database server. Check that a file was
created for the date on which the command was executed.
5. Transmit the metafile and temporary files to the backup server.
To transmit the SQL Server's metafile and temporary files collectively to the backup server, execute
EX_DRM_FTP_PUT on the database server. In this example, the user ID to log on to the FTP server
is admin and the login password is password. The metafile and temporary files are stored in
the temporary folder for extended commands, on the backup server.
DBServer > EX_DRM_FTP_PUT Operation_A -server BKServer -user admin -password password
6. Import the temporary files, which were transmitted from the database server, into the backup
catalog on the backup server.
To import the temporary files, which were transmitted from the database server, into the backup
catalog, execute EX_DRM_DB_IMPORT on the backup server.
BKServer > EX_DRM_DB_IMPORT Operation_A
After EX_DRM_DB_IMPORT is executed, an operation-ID.bid file is created in the
FTP_HOME_DIR-value\FTP_SUB_DIR-value\operation-ID\BK\ directory. Check that a file was
created for the date on which the command was executed.
7. On the backup server, deploy the metafile that was transmitted from the database server.
To deploy the metafile transmitted from the database server, execute EX_DRM_SQLFILE_EXTRACT
on the backup server.
At this time, only the latest metafiles are expanded on the backup server.
BKServer > EX_DRM_SQLFILE_EXTRACT Operation_A
8. Back up the data of the secondary volume to tape.
To back up the data of the secondary volume, execute EX_DRM_TAPE_BACKUP on the backup
server. In this example, the drive letter of the secondary volume is assumed to be E: in this
example.
BKServer > EX_DRM_TAPE_BACKUP Operation_A -mount_pt E:
Note that you can omit the -mount_pt option if the mount point defined in the configuration
definition file for tape backup (such as NBU.DAT) matches a mount point that is actually free.
When this backup is executed, the backup information is registered, with a new backup ID of
0000000002, in the backup catalog.
Operation for SQL Server databases300