HP XP Array Manager Software - Manual (Page 303)

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.
Restoring an SQL Server database from tape
This section provides an example of restoring an SQL Server database backed up to tape. This example
restores the data from tape to a secondary volume, and then restores the data from the secondary
volume to the the primary volume by resynchronizing the volumes. The operation ID is
Operation_A .
Restoring an SQL Server database
To restore the SQL Server database:
1. Check the backup ID of the backup you want to use for restoration.
Check the backup ID of the backup data to be used for restoring. To check the backup ID, execute
the
drmtapecat command on the backup server.
BKServer >drmtapecat -hostname DBServer -l
BACKUP-ID ORIGINAL-ID HOSTNAME BACKUP-OBJECT INSTANCE SNAPSHOT TIME EXPIRATION TIME
BACKUP-MEDIA
0000000002 0000000001 DBServer MSSQL instance1 2003/08/11 19:42:15 2003/11/11 19:42:15
-
:
:
If you perform restoration in units of instances, including a specific database, by executing the
restoration command with the
-target option specified, you must confirm the restoration target.
In this case, execute the drmtapecat command with the following options specified:
• -o MSSQL instance-name
• -backup_id backup-ID
2. Restore data from its backup tape to the secondary volume.
To restore data, execute EX_DRM_TAPE_RESTORE on the backup server.
If the
-mount_pt
option is specified during backup, specify the same mount point as specified
during backup. If the -mount_pt option is omitted during backup, it can also be omitted during
restoration.
BKServer > EX_DRM_TAPE_RESTORE Operation_A -backup_id 0000000002
-mount_pt E:
Application Agent CLI User Guide 303