HP StorageWorks P9000 Replication Manager Software 7.1 CLI User Guide (TB584-96026, May 2011)

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 StorageWorks P9000 Replication Manager Software 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 of SQL Server 2005 or SQL Server 2008 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
CLI User Guide 345