RE: Transaction replication / Distribution agent

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

Hi,

Thank you for your help. Now, I have reinitialised my deactivated
publications. (they got deactivated as it wasnt being synchronised for a long
time). I ran the snapshot agents for each of my 4 publications. I have got
the log reader delivering transactions now. but my distribution agent says
"The concurrent snapshot for the publication <publication_name> has not been
activated by the Log".

Does this mean that I need to wait untill the logreader finishes delivering
the transactions?????

Help appreciated.

Cheers.

"Vikram Kamath" wrote:

> Hi
>
> I have a transactional replication set up with a simple recovery model. My
> logreader seems to be doing its job by inserting data into the
> Ms_repl_commands table. But apparantly when i refresh the current activity on
> the SQL enterprise manager it hangs. I have noticed I have got a huge amount
> of locks on the distribution database on the same table. Any particular
> reason for this?
> Because i think this is why the enterprise manager is not responding.
>
> Secondly, when i run the distribution agent it says "the subscription(s)
> have been marked inactive and must be reinitialized. NoSync subscriptions
> will need to be dropped and recreated"
>
> I have noticed that the all my subscription's status is deactivated.
>
> I would like to know why it happened and how I can resolve it.
>
> Help much appreciated.
>
> Thanks in advance.
> Vikram
.

Relevant Pages

  • Re: Replication problems
    ... not yet have any Publications in my Enterprise Manager. ... configure the SQL Server Agent service to start automatically" or "No, ... I always created Databases ...
    (microsoft.public.sqlserver.ce)
  • Re: Is it posible to have publications with diferent schedules?
    ... but it does show up in your publication properties in the subscription ... Chances are however you will need to use sp_changepublication ... >>> The publications are all transactional and all publications use Push ... >>> My Question is can I have different Distribution Agent Schedules for ...
    (microsoft.public.sqlserver.replication)
  • Re: Is it posible to have publications with diferent schedules?
    ... "Hilary Cotter" wrote: ... >> The publications are all transactional and all publications use Push ... >> My Question is can I have different Distribution Agent Schedules for each ... >> schedules for each subscription but when I look in the Agents folder under ...
    (microsoft.public.sqlserver.replication)
  • Trans Replication with all types of objects published
    ... Correct me if im wrong but do i need to create many publications for SQL ... published in it and when the distribution agent runs, ... how do I fix this? ...
    (microsoft.public.sqlserver.replication)
  • Tidying up replication entries in Enterprise Manager
    ... I am trying to tidyup some remants of past publications. ... seem to be left is the publication itself and the snapshot part underneath ... SQL Server Enterprise Manager could not retrieve information about ...
    (microsoft.public.sqlserver.replication)