HP XP7 Replication Manager Application Agent CLI User Guide (TK981-96015, May 2014)

SQL Server database status
Commands
Uncon-
firmed
Read-onlyReadingOfflineOnline
NoNoNoNoYes (DB)
drmsqllogbackup
(when the -no_truncate
option is not specified)
NoYes (DB)
Yes (DB)
(becomes
read-only)
NoYes
drmsqlrecover
(when the -undo option is
specified)
No
Yes (DB)
(becomes
reading)
Yes (DB)NoYes
drmsqlrecover
(when the -loading option is
specified)
No
Yes (DB)
(becomes
online)
Yes (DB)
(becomes
online)
NoYes
drmsqlrecover
(when the -undo and
-loading options are not
specified)
No
Yes (DB)
(becomes
reading)
Yes (DB)NoNo
drmsqlrecovertool
(when the Loading option is
specified)
No
Yes (DB)
(becomes
read-only)
Yes (DB)NoNo
drmsqlrecovertool
(when the Standby option is
specified)
No
Yes (DB)
(becomes
online)
Yes (DB)
(becomes
online)
NoNo
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 databases288