December 19, 2017 at 2:30 am
Hi,
I have a transnational replication setup that has one publication and three subscribers.
The replication was working fine for an year. with all the three subscribers.
Right now data is not sync'ing to one of the subscribers.
When I check the synchronization status I see the message - 'No replicated transactions are available'.
I don't see errors on replication monitor.
I tried to re-snap with the following two options
1.Truncate tables at subscriber
2. drop and recreate the tables at the subscription.
I don't see any issues with the re-snap. But the data is not replicated to subscriber.
When I chose the option to drop and recreate the tables at subscription , it didn't actually dropped the tables. But again no errors and the synchronization status remains the same
'No replicated transactions are available'..
Then I manually deleted the tables at the subscriber and then re-snapped , no errors and still the synchronization status remains the same.
'No replicated transactions are available'..
No errors on the replication monitor as well.
I am not able to understand why I am not seeing a repliction failure since there are no tables at subscriber and no tables are created as part of the re-snap.
Any help would be much appreciated.
Thanks.
December 19, 2017 at 4:04 am
is the log reader agent running successfully?
is the distributor local or remote to the publisher?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 19, 2017 at 9:06 am
1.Log reader is running successfully, the replication is flowing two other subscribers with no issues.
2.The distribution servere is a remote dedicated server to this publication server.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply