Restore Order

Hi NG,
I have a question regarding the restore order of databases in case of
total desaster on the same server. I use KEEP_REPLICATION.
1. master
2. msdb
--> Stop all jobs in msdb
3. distribution
4. replication database
Is these sequence OK?
thanks in advance
Thomas
Is my question incorrectly?
On Tue, 08 Mar 2005 16:48:12 GMT, tohas@.freenet.de (Thomas Hase)
wrote:

>Hi NG,
>I have a question regarding the restore order of databases in case of
>total desaster on the same server. I use KEEP_REPLICATION.
>1. master
>2. msdb
>--> Stop all jobs in msdb
>3. distribution
>4. replication database
>Is these sequence OK?
>thanks in advance
>Thomas
|||I would tend to restore MSDB last, in case any jobs start
before everything's ready. Also if you are talking about
transactional publications, the 'sync with backup' option
is important. Finally, the servername must be identical
on the newly rebuilt server.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)