HP Serveur lame HP ProLiant BL465c Gen8 User Manual

Page 280

Advertising
background image

Figure 73 Backing up and restoring multiple databases (same volume configuration)

When multiple databases are stored in multiple volumes

You can specify database names to back up or restore particular user databases within an instance

#

.

The following figure shows backup and restoration for databases stored on the multiple volume.

Figure 74 Backing up and restoring multiple databases (multiple volume configuration)

#

When one instance contains multiple user databases, you can use Application Agent to specify
a particular instance name, and back up all user databases under that instance. To use this
functionality, however, you must move or delete the sample database created during SQL Server
installation. As a result, if one instance contains multiple user databases to be backed up, obtain
backups by specifying multiple database names for

TARGET

, in the operation definition file for

extended commands.

Application Agent treats as restored any databases restored to the primary volume by data restored
to the secondary volume from tape.

Operation for SQL Server databases

280

Advertising