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

SQL Server database status
Commands
Read-only,
offline, and
uncon-
firmed
Read-only
and uncon-
firmed
Read-only
and offline
Reading
and uncon-
firmed Offline and
uncon-
firmed
No No No No No
drmsqlrecovertool
(when the Standby option is
specified)
No No No No No
drmsqlrecovertool
(when the Online option is
specified)
Yes (DB)
#
(becomes
read-only)
Yes (DB)
#
(becomes
read-only)
Yes (DB)
(becomes
read-only)
Yes (DB)
#
(becomes
read-only)
Yes (DB)
#
(becomes
read-only)
drmsqlrestore
(when the -undo option is
specified)
Yes (DB)
#
(becomes
reading)
Yes (DB)
#
(becomes
reading)
Yes (DB)
(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.
Yes: The command can be executed; however, no operation is performed on the database.
No: The command cannot be executed.
#
If the database is in the unconfirmed status, it will be deleted and then restored automatically.
Database type
Table 100 Relationship between the type of the sql server database and executable commands
SQL Server database type
Commands
User database
System database
tempdb model msdb master
Yes (DB) -- Yes (DB) Yes (DB) Yes (DB) drmsqlbackup
Yes Yes Yes Yes Yes drmsqlcat
Yes Yes Yes Yes Yes drmsqldisplay
Yes Yes Yes Yes Yes drmsqlinit
Yes (DB)
#2
No
(No
operation is
performed)
#1
No
(No
operation is
performed)
#1
No
(No
operation is
performed)
#1
No
(No
operation is
performed)
#1
drmsqllogbackup
Operation for SQL Server databases 292