Re: Win 2003 upgrade

I can't comment on why this has happened with the upgrade. It is unusual to
see these messages however. I would stop SQL Server agent to see if this
fixes the problem (there could be rogue pull distribution agents running).
Then I would start it up SQL Server agent and see if I can't identify the
problem agents in query analyzer using the sp_who2 command and profiler.

For the problem with the retention period of expiring subscribers, check
that the history retention period is the same as the subscription retention
period.

--
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



"LPR-3rd" <lreames@xxxxxxxxx> wrote in message
news:1145885720.711889.135060@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Recently, all of my SQL 2000 Servers O/S were upgraded (new install) to
Win 2003. Ever since, I am having a couple of problems with most of
the subscriptions.

The first is....
'Another distribution agent for the subscription(s) is running.'
I have researched this error/message and have discovered that if I end
DISTRIB.EXE, this would fix this problem. Well when you are managing
one server this is not a problem, but in my case, it is not easily
done. So my question is....why is this happening?? All the
replication jobs, both publications & subscriptions were recreated
after the the OS was installed.

The second is....
'The subscription has not been synchronized within the maximum
retention period or it has been dropped at the Publisher. You
must reinitialize the subscription to receive data. The step failed.'
Why is this happening all of a sudden?? How do I verfiy the retention
period on the publications?


ANIA,
Larry...



.

Relevant Pages

  • Re: Replication for non-trusted domains through VPN can only allow push subscription.
    ... the repldata share on the publisher because the SQL Server Agent account on ... pass-through accounts to prevent the Windows Domain Account problem. ... What are the steps to setup and verify the pull subscription that I must ... > There are two modes - windows authentication and SQL Server Standard ...
    (microsoft.public.sqlserver.replication)
  • Re: Replication for non-trusted domains through VPN can only allow push subscription.
    ... the repldata share on the publisher because the SQL Server Agent account on ... pass-through accounts to prevent the Windows Domain Account problem. ... What are the steps to setup and verify the pull subscription that I must ... > There are two modes - windows authentication and SQL Server Standard ...
    (microsoft.public.sqlserver.connect)
  • Re: Replication for non-trusted domains through VPN can only allow push subscription.
    ... the repldata share on the publisher because the SQL Server Agent account on ... pass-through accounts to prevent the Windows Domain Account problem. ... What are the steps to setup and verify the pull subscription that I must ... > There are two modes - windows authentication and SQL Server Standard ...
    (microsoft.public.sqlserver.security)
  • Re: Merge Replication MS SQL CE 3.5 <-> SQL SERVER 2005
    ... subscription, ... I had to uninstall SQL Server v3.5 SP1 and reinstall the standard ... The directory "C:\Program Files\Microsoft SQL Server Compact ... Install SQL Server 2005 ...
    (microsoft.public.sqlserver.ce)
  • Re: Replication for non-trusted domains through VPN can only allow push subscription.
    ... >> Publisher, Distributor, and Subscriber talk to each other using RPC ... > the repldata share on the publisher because the SQL Server Agent account ... > What are the steps to setup and verify the pull subscription that I must ... >> the repldata share on the publisher because the SQL Server Agent account ...
    (microsoft.public.sqlserver.replication)