Backing up and restoring – HP Serveur lame HP ProLiant BL465c Gen8 User Manual

Page 352

Advertising
background image

2.

Place the standby database online.

To use a Application Agent command after restoring the database, execute the

drmsqldisplay

command with the

-refresh

option.

Backing up and restoring in a cascade configuration or
multi-target configuration

Application Agent supports backups to and restorations from a secondary volume at a remote site (in
a cascade configuration). When backing up data to the secondary volume at the remote site, you
can also back up the same data on the secondary volume at the local site (backup in a multi-target
configuration).

This section explains how to back up an SQL Server database to, and restore it from, a secondary
volume at a remote site (how to perform backup and restoration in a cascade configuration). For
backup operation in a cascade configuration, a user-created script file is used.

This example is based on the system configuration shown in following diagram.

Figure 101 Sample configuration for backing up to a secondary volume at a remote site (cascade
configuration)

The following conditions are assumed:

Operation for SQL Server databases

352

Advertising