Replication/Subscription error
in [Replication]
|
From: Hilary Cotter on 10 Apr 2006 20:53 Right click on your publication, select properties, go to the subscriptions tab and highlight the subscription and delete it there. -- Hilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com "Hilary Cotter" <hilary.cotter(a)gmail.com> wrote in message news:eC18JZNXGHA.4976(a)TK2MSFTNGP03.phx.gbl... > Unfortunately you really reinitialize. You could do a no-sync and then run > a verify, figure out which tables are out of sync, and then use a tool > like Red-Gate's data compare to make sure that they are in sync. > -- > Hilary Cotter > Director of Text Mining and Database Strategy > RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. > > This posting is my own and doesn't necessarily represent RelevantNoise's > positions, strategies or opinions. > > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > > > > "sqldba" <sqldba(a)abc.com> wrote in message > news:51c74805c130438a8e675af756753755(a)ureader.com... >>i match the history retention to distribution retention. do i have to >> re-snapshot or & re-initialise. i will appreciate if you give some steps >> to >> follow to resolve this issue. >> >> I stopped Log reader & did re-snap, but still i am seeing the same error. > > |