Manualshelf

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

ManualsBrandsHP ManualsSoftwareHP XP Array Manager Enterprise Media Kit
301302303304305306307308309310
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:
3. Export the backup information to temporary files.
To restore data from the secondary volume to the primary volume, the backup information about
the restore operation from tape to the secondary volume needs to be copied to the database
server. To export the backup information to temporary files, execute EX_DRM_DB_EXPORT. These
temporary files are stored in the temporary folder for extended commands.
BKServer > EX_DRM_DB_EXPORT Operation_A
CLI User Guide 301