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

Specify the backup ID used when the databases, including the system databases, were backed
up, and execute the drmsqlrestore command on the publisher/distributor server or the subscriber
server.
PROMPT > drmsqlrestore 0000000005 -resync -target master,model,msdb
PROMPT >
• Restore the subscription database
On the subscriber server, execute the drmsqlrestore command.
PROMPT > drmsqlrestore 0000000002 -resync -target SubUserDB1
PROMPT >
Perform database recovery
Use the drmsqlrecover command or the drmsqlrecovertool command to perform a recovery
(roll forward) by using the normal procedure.
Prepare to restart operations
The following must be prepared in order to restart SQL Server replication operations:
The server that performs these operations will depend on the subscription format, as follows:
Push subscription: Publisher/distributor server
Pull subscription: Subscriber server
1. Start the log reader agent.
2. Start the subscription agent.
Synchronous subscription is started.
3. Perform subscription re-initialization or deletion and re-creation.
Setting and checking the 'sync with backup' option
When the SQL Server replication function is used, the 'sync with backup' option must be set for
the publication database and the distribution database.
When backup is performed on the publication database transaction logs with the 'sync with
backup' option set, the backup is forwarded to the distribution database. Also, no publication
database logs will be dropped until all transactions are forwarded to the distribution database.
How to set the 'sync with backup' option
When creating the replication environment, execute the following stored procedure on the production
database and distribution database. For details about how to execute stored procedures, see SQL
Server Books Online.
Operation for SQL Server databases392