HP XP P9000 Replication Manager Software 7.6.1-00 Application Agent CLI User Guide

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
NoNoNoNoNo
drmsqlrecovertool
(when the Standby option is
specified)
NoNoNoNoNo
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
tempdbmodelmsdbmaster
Yes (DB)--Yes (DB)Yes (DB)Yes (DB)
drmsqlbackup
YesYesYesYesYes
drmsqlcat
YesYesYesYesYes
drmsqldisplay
YesYesYesYesYes
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 databases292