sql server replication: Restarting a Transactional Subscription -- sql server replication

Restarting a Transactional Subscription

Asia
5/13/2004 2:17:23 PM

sql server replication: Dear All,
Our Production server crashed and is currently being
repaired. When Its back on line I am going to copy the
infomation from our DRS Transactional Replicated Server
to the Production, however I would like to ask a couple
of questions.

1. Our distributor is on our DRS server, how do I
temporary turn it off so it does not look for updates
when production is switched on.

After the data from DRS is copied back to the Production
server

2. How do I re-start the replication with a snapshot (our
snapshot deletes and re-creates the tables)

Re: Restarting a Transactional Subscription

Asia
5/14/2004 1:23:30 AM

Thanks Paul.

:-)

[quoted text, click to view]

Re: Restarting a Transactional Subscription

Paul Ibison
5/14/2004 8:35:11 AM

1) you can turn off the sql agent service, or turn off the relevant agents
(jobs).
2) restarting replication with a snapshot is referred to as initialization,
so reinitialize is what you will need to do.
HTH,
Paul Ibison

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.