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

Restore the databases
• Restore the publication database
Specify the backup ID used when the publication database and the distribution database were
backed up, and execute the
drmsqlrestore command on the publisher/distributor server.
PROMPT> drmsqlrestore 0000000001 -resync
PROMPT>
If you are specifying the backup ID used when backing up the databases, including the system
databases, specify the publication database and the distribution database in the
-target option
or -f option and execute the drmsqlrestore command.
PROMPT> drmsqlrestore 0000000005 -resync -target PubUserDB1,distribution
PROMPT>
• Restore the publication database and the system databases
The following procedure must be followed to restore the publication and system databases on the
publisher/distributor server.
1. Restore the system databases
PROMPT> drmsqlrestore 0000000005 -resync -target master,model,msdb
PROMPT>
2. Stop the log reader agent.
3. Stop the agent associated with subscription.
A subscription synchronous stop is performed.
NOTE:
If the log reader agent start option is set to Automatically startup during SQL
Server agent startup , the log reader agent will be started after the master, model,
and msdb databases are restored, and an error will occur when the publication database
and distribution database are restored.
4. Restore the publication database and distribution database.
PROMPT> drmsqlrestore 0000000005 -resync -target
PubUserDB1,distribution
PROMPT>
Operation for SQL Server databases 392