beautypg.com

About sql database and service status – HP XP P9000 Command View Advanced Edition Software User Manual

Page 399

background image

Related topics

Using Database Availability Groups (DAGs)

, page 397

About SQL database and service status

When Replication Manager is used to restore data from a secondary volume to a primary volume,
the status of the database becomes either loading or standby:

Loading status (loading)
The database can neither be viewed nor updated.

Standby status (read-only)
The database can be viewed, but not updated.

Transaction logs can be applied to databases in the loading status and standby status using
Management Studio.

You can set database instances to be restored in standby using Restore Task Options in the SQL
Options tab of the Setup Application Agent window (including setting the UNDO log file location).
The Restore Replica Wizard includes an option to restore with loading status.

NOTE:

You cannot perform a backup on databases in loading or standby status. Use Management Studio
to change the status of the database so that it can be viewed and updated.

The following tables summarize database and service status and the operations that can be performed.

Table 21 SQL Server database status and user actions supported

SQL Server database status

User action

Read-
only,
Off-
line,
and
Un-
con-
firmed

Read-
only
and
Un-
con-
firmed

Read-
only
and
Off-
line

Load-
ing
and
Un-
con-
firmed

Off-
line
and
Un-
con-
firmed

Un-
con-
firmed

Read-
only

Load-
ing

Off-
line

On-
line

x

x

x

x

x

x

x

x

x

Create replicas

o

o

o

o

o

o

o

o

o

Update task inform-
ation

Update host inform-
ation

x

x

x

x

x

o

o

o

o

o

Configure Applica-
tion Agent Settings

x

x

x

x

x

x

3

3

x

o

Point-in-time restore

2

2

2

2

2

1

Roll-forward restore

(standby)

4

User Guide

399

This manual is related to the following products: