Restoring an sql server database from tape, Restoring an sql server database – HP Serveur lame HP ProLiant BL465c Gen8 User Manual

Page 303

Advertising
background image

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

Advertising