all groups > sql server replication > december 2006 >
You're in the

sql server replication

group:

Resyncronize publication and subscription



Resyncronize publication and subscription Iter
12/13/2006 7:49:01 PM
sql server replication: I have two databases that are used for publication and subscription. One
table in subscription was droped by accidence and replication was failed.
After I re-create that table and Re-syncronize them, I still got failed and
error was like that table is not existed. No matter how I did, it was failed.
Could someone tell me how to Resyncronize it? Thanks.
Re: Resyncronize publication and subscription Paul Ibison
12/14/2006 12:00:00 AM
Presumably the initial error occurred because a command was being executed
by the distribution agent against the non-existant table. After that you
recreated the table and 're-synchronized them' - can you clarify this bit?
Presumably this means you just ran the distribution agent again? Was the
table at the subscriber already populated? How did you ensure that the table
was populated correctly in a way that its contents were consistant with the
state implied by the contents (commands) of the distribution database? The
best way to remedy this is to drop the subscriptions to the table, drop the
table from the publication then readd both the table and the subscriptions
and run the snapshot agent. This will effectively reinitialize the table.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

AddThis Social Bookmark Button