HP Serveur lame HP ProLiant BL465c Gen8 User Manual
Page 288
SQL Server database status
Commands
Uncon-
firmed
Read-only
Reading
Offline
Online
No
No
No
No
Yes (DB)
drmsqllogbackup
(when the
-no_truncate
option is not specified)
No
Yes (DB)
Yes (DB)
(becomes
read-only)
No
Yes
drmsqlrecover
(when the
-undo
option is
specified
)
No
Yes (DB)
(becomes
reading)
Yes (DB)
No
Yes
drmsqlrecover
(when the
-loading
option is
specified
)
No
Yes (DB)
(becomes
online)
Yes (DB)
(becomes
online)
No
Yes
drmsqlrecover
(when the
-undo
and
-loading
options are not
specified)
No
Yes (DB)
(becomes
reading)
Yes (DB)
No
No
drmsqlrecovertool
(when the Loading option is
specified)
No
Yes (DB)
(becomes
read-only)
Yes (DB)
No
No
drmsqlrecovertool
(when the Standby option is
specified)
No
Yes (DB)
(becomes
online)
Yes (DB)
(becomes
online)
No
No
drmsqlrecovertool
(when the Online option is
specified)
Yes (DB)
#2
(becomes
read-only)
Yes (DB)
(becomes
read-only)
Conditional
#1
(becomes
read-only)
Yes (DB)
(becomes
read-only)
Yes (DB)
(becomes
read-only)
drmsqlrestore
(when the
-undo
option is
specified)
Yes (DB)
#2
(becomes
reading)
Yes (DB)
(becomes
reading)
Conditional
#1
(becomes
reading)
Yes (DB)
(becomes
reading)
Yes (DB)
(becomes
reading)
drmsqlrestore
(when the
-undo
option is not
specified)
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.
Conditional: The command can be executed in certain conditions. (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.
#1
The command can be executed when restoration of the system databases (master, model, and
msdb) is included.
Operation for SQL Server databases
288