MS SQL Server Replication - What's the Easiest Way to Backout and Redo Replication?

Author

What's the Easiest Way to Backout and Redo Replication?

CChamblee

2005-07-22, 3:24 am

I'm having numerous problems getting a good snapshot and subsequently
pushing a subscription out. I'm thinking about just redoing the whole
process. Is there a simple procedure for doing this? At this point,
I'll take even a complex procedure to do it. Maybe if I could just
redo my snapshot successfully, that would solve my problem. How do
you force a new snapshot?

Paul Ibison

2005-07-22, 3:24 am

I'm not sure I follow exactly what is happening in your case, but
sp_reinitsubscriptio
n (or variations thereof) will mark the subscription for
reinitialization, and running the snapshot agent and distribution/merge
agents will send the snapshot down.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

OzSQL

2005-07-22, 8:23 pm

"" wrote:
> I'm having numerous problems getting a good snapshot and
> subsequently
> pushing a subscription out. I'm thinking about just redoing
> the whole
> process. Is there a simple procedure for doing this? At this
> point,
> I'll take even a complex procedure to do it. Maybe if I could
> just
> redo my snapshot successfully, that would solve my problem.
> How do
> you force a new snapshot?

You should just be able to "reinitialize" the subscription - this
will force a new snap shot to be created and pushed out.

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/Replication...pict242359.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=842317

Sponsored Links