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

7. Restore the data from the secondary volume to the primary volume.
Restore the data by resynchronizing the primary and secondary volumes. To restore the data,
execute the drmsqlrestore command on database server 2.
PROMPT> drmsqlrestore 0000000001 -resync -nochk_host
KAVX0001-I The drmsqlrestore command will now start.
KAVX1316-I Performing restore pre-processing...
KAVX1000-I Logged on to the SQL Server system.
KAVX1300-I Restore processing will now start.
KAVX1000-I Logged on to the SQL Server system.
KAVX1301-I Restore processing has finished.
KAVX1318-I Performing restore post-processing...
KAVX1001-I Logged off from the SQL Server system.
KAVX0002-I The drmsqlrestore command will now end.
PROMPT>
8. Recover the SQL Server database.
To recover the SQL Server database, execute the drmsqlrecover or drmsqlrecovertool
command on database server 2.
• The following example uses the drmsqlrecover command:
PROMPT> drmsqlrecover SQL1
KAVX0001-I The drmsqlrecover command will now start.
KAVX1017-I SQL Server information is being collected now.
KAVX1302-I Recovery processing will now start.
KAVX1303-I Recovery processing has finished.
KAVX0002-I The drmsqlrecover command will now end.
PROMPT>
• The following example uses the drmsqlrecovertool command:
PROMPT> drmsqlrecovertool SQL1
PROMPT>
When you execute this command, the drmsqlrecovertool dialog box appears. For details on
this dialog box, see the description of the drmsqlrecovertool command in the manual
HP XP7 Replication Manager Application Agent CLI Reference Guide.
Using the SQL Server log-shipping function
The log-shipping function of an SQL Server database allows you to continuously copy backup
transaction log data to a destination server. This section describes the preparations and settings
needed to use this function.
Before using the log-shipping function
The log-shipping functionality can be used when an SQL Server database is to be backed up. Using
the log-shipping functionality, you can continuously copy backed-up transaction logs to a distribution
server so that it can be used as an operation server. For details on the log-shipping functionality, see
the SQL Server manual. This section provides an example of synchronizing the database on a source
server and the database on a distribution server and setting log-shipping operations on the source
server before using the log-shipping functionality of SQL Server. This explanation assumes the system
configuration shown in the following figure.
Operation for SQL Server databases346