Re: distribution clean up not working

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

How do I find out ? And if they are enabled, how do i turn them off ? I know
making certain settings to a publication causes the whole publication to
initilaize and resnapshot.

It happened once to me when i changed it to concurrent snapshot while
replication was on and next thing i know it triggered a reinitialisation and
all my objects were being snapshot.


"Paul Ibison" <Paul.Ibison@xxxxxxxxxxxxx> wrote in message
news:esOIyMDbFHA.2696@xxxxxxxxxxxxxxxxxxxxxxx
> Do you have anonymous subscribers enabled? If so, the commands will hand
> around until the transaction retention perios is reached.
> Rgds,
> Paul Ibison, SQL MVP
>
>


.

Relevant Pages

  • Re: Need help - desperate
    ... I executed the command and recreated the publication and subscription. ... If generation of the concurrent snapshot was ... that there were no jobs running with this database name. ...
    (microsoft.public.sqlserver.replication)
  • FYI: Tab Settings Default back to Original Settings Workaround
    ... to the tab issue for losing their settings after closing a publication. ... Publisher 2002/03. ...
    (microsoft.public.publisher)
  • Default setting in pub 2003
    ... the default settings when I open a new publication? ... The layout guides ... The font used in new text boxes ...
    (microsoft.public.publisher)
  • Adding column to Merge Pub
    ... I have a merge publication (SQL 2k) and needed to add a column to a ... I used the stored proc and settings below and it seemed ...
    (microsoft.public.sqlserver.replication)