Restoring an sql server database in a cascade, Configuration – HP Serveur lame HP ProLiant BL465c Gen8 User Manual

Page 371

Advertising
background image

10.

Unmount the secondary volume.

To unmount the secondary volume, specify the backup ID used when mounting

0000000002

.

This step must be performed on the backup server at the remote site.

PROMPT> drmumount 0000000002

KAVX0001-I The drmumount command will now start.

KAVX0406-I Unmounting will now start.

Mount point = E:

KAVX0407-I Unmounting has finished.

Mount point = E:

11.

Check the backup to tape execution results.

Confirm that backup to tape finished successfully. To confirm this, execute the

drmtapecat

command on the backup server at the remote site.

PROMPT> drmtapecat 0000000003

BACKUP-ID BACKUP-OBJECT SNAPSHOT TIME EXPIRATION TIME BACKUP-MEDIA

0000000003 MSSQL 2004/02/04 13:01:35 2004/05/04 13:01:35 MEDIA1

PROMPT>

Backing up transaction logs in a cascade configuration without a backup catalog

This section explains the steps for backing up transaction logs in a cascade configuration when the
backup catalog does not exist.

Here, because the starting point for backing up transaction logs is an SQL Server database that is
backed up only to a secondary volume of a remote site by the

drmsqlbackup

command with the

-script

option, the

-no_cat

option is used.

Back up the transaction logs.

Back up the transaction logs. To back up the transaction logs, execute the

drmsqllogbackup

command on the database server at the local site.

PROMPT> drmsqllogbackup default -no_cat

KAVX0001-I The drmsqllogbackup command will now start.

KAVX0002-I The drmsqllogbackup command will now end.

Restoring an SQL Server database in a cascade configuration

This section explains the steps for restoring SQL Server database data, which was backed up from
the remote site secondary volume to tape, to the local site (restoration in a cascade configuration).

To restore an SQL Server database in a cascade configuration:

1.

Stop the SQL Server service at the local site.

2.

Unmount the secondary volume at the local site.

Application Agent CLI User Guide

371

Advertising