HP XP Racks User Manual
Page 402
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
(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 21 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.
Managing application replicas
402