HP Serveur lame HP ProLiant BL465c Gen8 - 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