About sql database and service status – HP XP Racks User Manual
Page 401
Related topics
• Using Database Availability Groups (DAGs)
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 20 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
401