HP XP P9000 Command View Advanced Edition Software - Manual (Page 413)

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
•
2
•
2 • •
2
•
2
•
2 • •
1 • •
Roll-forward restore
(standby)
4
•
2
•
2 • •
2
•
2
•
2 • •
1 • •
Roll-forward restore
(loading)
5
Legend:
• : Action permitted and database changes are allowed.
o : Action permitted and no database changes allowed.
x : Action not permitted.
Notes:
1. Action permitted if the restore includes the system databases (master, model, and msdb). If only
user databases are being restored, first remove any databases that are not ready to be restored.
2. A database in the "Unconfirmed" status is automatically removed and restored.
3. After the action, databases are put into the "Online" status.
4. After the action, databases are put into the "Read-only" status.
5. After the action, databases are put into the "Loading" status.
Table 24 SQL Server service status and user actions supported
Service status
User action
Stopped Started
x • Create replicas
• • Update task information
x • Update host information
x • Configure Application Agent Settings
• • Restore both user and system databases
x • Restore user databases only
Legend:
• : Action permitted.
User Guide 413