Backing up and restoring data between volumes, System configuration – HP Serveur lame HP ProLiant BL465c Gen8 User Manual

Page 291

Advertising
background image

SQL Server database type

Commands

User database

System database

tempdb

model

msdb

master

Yes (DB)

No

(terminates

with an error)

No

(No

operation is

performed)

No

(No

operation is

performed)

No

(No

operation is

performed)

drmsqlrecover

Yes (DB)

No

(terminates

with an error)

No

(No

operation is

performed)

No

(No

operation is

performed)

No

(No

operation is

performed)

drmsqlrecovertool

Yes (DB)

Yes

Yes (DB)

Yes (DB)

Yes (DB)

drmsqlrestore

Legend:

Yes (DB): The command can be executed and the operations are performed on the database.
The database status after the operations is displayed in parenthesis.
Yes: The command can be executed, however, no operation is performed on the database.
No: The command cannot be executed. The command behavior is displayed in parenthesis.

--: Not applicable to command execution

#1

When the

-target

option or

-t

option is specified, the command terminates with an error.

#2

The command is executable only when the recovery type of the database is Full or Bulk_Logged.

Backing up and restoring data between volumes

This section describes how to back up and restore data between the primary and secondary volumes.

System configuration

In a configuration that uses only one server, you use commands to back up and restore data between
the primary volume and secondary volume. Install Application Agent on the database server and
execute the appropriate commands.

The following figure shows a system configuration for backing up and restoring data between volumes.

Application Agent CLI User Guide

291

Advertising