Hi,
For some magical reason, my database replication has suddenly stopped
working. I modified the publication but the Distribution agent will
not run; the snapshot does not get applied to the subscriber, and
changes made at the publisher do not get replicated.
My configuration is: Transactional Replication with a 'Pull'
Subscription. The Subscriber is Updateable with Immediate Updates
Only. All created via the SQL Server Enterprise Manager. Both the
Publisher and Subscriber are on the same server. I'm running SQL
Server 2000 (8.00.760 SP3), on Windows 2000 Server (5.0 (2195)).
I manually run the snapshop agent. It runs fine with the status
'Succeeded' and the Last Action is 'A Snapshot of X article(s) was
generated'.
When I look at the distribution agent, things start to get a bit
confusing in ( <SERVERNAME>/Replication Monitor/ Publishers/
<SERVERNAME?>/ Publication/ Subscription), the status stays
constantly at 'Never Started'. All other columns are either blank or
0. When I right click over the subscription, both Start Synchronising
and Stop Synchronising are NOT greyed out. If I click on either Start
Synchronising or Stop Synchronising (absolutely) nothing happens
(except the mouse turns 'busy' for a fraction of a second). There are
no error messages.
I added -output c:\sqlout.txt -outputverbosele vel 3 to the
distribution agent command. C:\sqlout.txt did not get created.
It worked fine up to a couple of days ago. I'm not sure exactly what
caused the problem, as I made a few changes at the same time. The
changes included: adding a new transactional publication, adding more
articles to an existing transaction publication, and adding a merge
publication. I've tried to go back to the set up before I made the
changes, even disabling replication and starting again from scratch.
Still the problem persists.
The owner of the distribution agent has dbo permissions in both the
publishing and subscribing database. Under 'Publisher and Distributor
Properties' I've set the 'Replication Agent Connection to Publisher'
and 'Agent Connection to the Subscriber' both to Use SQL Server
Authentication, both with the same account that has dbo permissions in
both publishing and subscribing database.
Has anybody come across this problem before? Can anybody make any
suggestions? Thanks in advance for your help.
Regards
Damian Helme
IS Manager
INTEC Engineering (UK) Ltd. 1 5665
"Damian H" <da*********@ho tmail.com> wrote in message
news:2b******** *************** ***@posting.goo gle.com... Hi,
For some magical reason, my database replication has suddenly stopped working. I modified the publication but the Distribution agent will not run; the snapshot does not get applied to the subscriber, and changes made at the publisher do not get replicated.
My configuration is: Transactional Replication with a 'Pull' Subscription. The Subscriber is Updateable with Immediate Updates Only. All created via the SQL Server Enterprise Manager. Both the Publisher and Subscriber are on the same server. I'm running SQL Server 2000 (8.00.760 SP3), on Windows 2000 Server (5.0 (2195)).
I manually run the snapshop agent. It runs fine with the status 'Succeeded' and the Last Action is 'A Snapshot of X article(s) was generated'.
When I look at the distribution agent, things start to get a bit confusing in ( <SERVERNAME>/Replication Monitor/ Publishers/ <SERVERNAME?>/ Publication/ Subscription), the status stays constantly at 'Never Started'. All other columns are either blank or 0. When I right click over the subscription, both Start Synchronising and Stop Synchronising are NOT greyed out. If I click on either Start Synchronising or Stop Synchronising (absolutely) nothing happens (except the mouse turns 'busy' for a fraction of a second). There are no error messages.
I added -output c:\sqlout.txt -outputverbosele vel 3 to the distribution agent command. C:\sqlout.txt did not get created.
It worked fine up to a couple of days ago. I'm not sure exactly what caused the problem, as I made a few changes at the same time. The changes included: adding a new transactional publication, adding more articles to an existing transaction publication, and adding a merge publication. I've tried to go back to the set up before I made the changes, even disabling replication and starting again from scratch. Still the problem persists.
The owner of the distribution agent has dbo permissions in both the publishing and subscribing database. Under 'Publisher and Distributor Properties' I've set the 'Replication Agent Connection to Publisher' and 'Agent Connection to the Subscriber' both to Use SQL Server Authentication, both with the same account that has dbo permissions in both publishing and subscribing database.
Has anybody come across this problem before? Can anybody make any suggestions? Thanks in advance for your help.
Regards
Damian Helme IS Manager INTEC Engineering (UK) Ltd.
You might want to post this in microsoft.publi c.sqlserver.rep lication, as
you may get a better answer over there.
Simon This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Sridhar G |
last post by:
Hi,
I have implemented Snapshot replication on my database server. The
publisher, distributor and the subscriber are in the same machine.
There is a database 'X' that gets replicated every night to database
'Reportdb' on the same machine.
The snapshot agent is scheduled to run every night at 10pm on all
weekdays except sunday.
|
by: Doug |
last post by:
Working with SQL Servers' transactional replication I am having a
problem with the subscribers log growing to the size of the full
database that I am replicating. Currently I have a 53 gig database
that I have setup as my publisher. My distributor is on another server
with the subscriber. I am also using the "sync with backup" DB option.
I have log jobs running every five minutes on the publisher and the
distributor.
My snapshot agent is...
|
by: Ref |
last post by:
Hi
I am new with Replication
I develop Now the Microsoft Server 2000 Replication
And I chose Snapshot type for replication
All I need to copy Part of db from Publisher via distributor to
Subscriber
I tried with Windows xp pro
|
by: Louis Frolio |
last post by:
Greetings All, I was hoping that a replication sage might be able to
answer a question for me.
I want to have one subscriber subscribing to N publishers. I
essentially have a company that has a main headquarters and three
satellite offices. I want each of the satellite offices to push their
data up to the master database. From what I have read it seems like
this should not be a problem. Some questions that come to mind are:
...
|
by: war_wheelan |
last post by:
I have a TSQL script to add daily tables to replication and then run
the snapshot agent to distribute them to two subscribers. The script
executes without errors, but when I check the running jobs for each
server I see the following:
JUST AN EXAMPLE
Job1 'Category' REPL-Snapshot
Job2 'Category' REPL-Distribution
What is the difference between these two categories? Also 'Job1' works
| |
by: Gary Lou |
last post by:
Hi All,
I have set up a snapshot replication, and schedule it to run every
night. The snapshot run successfully, and data get replicated to the
subscribed server. However, data do not get transfer as the second day
and there after. I check the job history, the job (distribution) run
successfully. I start the snapshot agent again, then data get
transferred. I can schedule the snapshot agent to run every night, but
this is just not the...
|
by: Query Builder |
last post by:
I have a wired situation..!
I set up transactional replication on one of my development server (SQL
2000 Dev Edition with sp4).
It is running fine without any issues and all of a sudden, i noticed in
my repication monitor tab under Publisher where I usually see the
publication is empty now.
I do see the snapshot agent, log reader and distribution agent under my
|
by: ceadtinneh |
last post by:
First a bit about what I' trying to do.
I'm running SQL Server 2005 Developer edition on my dev box. I've got
two instances set up and am trying to set up transactional replication
(with both immediate and queued updates) between the two instances.
The windows account I'm using to run the replication agents (dist,
logreader, snapshot and queuereader) is a domain account with the same
rights as the SQLServerAgent on my box.
|
by: bourgon |
last post by:
I'm getting this, after upgrading from 2000 to 2005.
Replication-Replication Distribution Subsystem: agent (null) failed.
The subscription to publication '(null)' has expired or does not
exist.
The only suggestions I've seen are to dump all subscriptions. Since
we have several dozen publications to several servers, is there a
decent way to script it all out, if that's the only suggestion?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |