HP Serveur lame HP ProLiant BL465c Gen8 - Manual (Page 350)

8. Restore the backup data to the distribution target server volumes.
Check that the backup data has been copied to the distribution target server volumes, and then
restore the backup data from the distribution target server. When restoring, apply the metafile
to the backup data without recovering the backup data from the secondary volumes to the primary
volumes, and place the database into standby status. To restore in this manner, execute the
drmsqlrestore command as shown below:
PROMPT> drmsqlrestore 0000000001 -no_resync -undo -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>
9. Set up log-shipping operations on the source server.
Specify the settings, such as the distribution server and the frequency of log creation, for
log-shipping operations on the source server.
For information on how to set up log-shipping operations, see the SQL Server documentation.
Setting a distribution target server as an operating server
This section provides an example of how to set up a distribution target server as an operating server
when using the log-shipping functionality of SQL Server, if such an action is required due to a failure
on the source server during log-shipping operations or for some other reason. This explanation assumes
the system configuration shown in the following figure.
Operation for SQL Server databases 350