June 18, 2012 at 11:33 am
Hello All,
This is my first time setting up replication, so please bare with me. I am using transactional replication. The distributor, publisher and subscriber are all on separate servers. I log into the distributor and look at replication monitor and the snapshot agent shows that my publication completed, but that's it. How am I supposed to tell if the data moved over to the subscriber? I checked the subscriber and don't see the data (tables, sp, etc) moved over the subscriber DB. What do I do to check this or to start the process of it moving over. I am on SQL Server 2008 R2 SP1. Any help would be greatly appreciated.
Thank you.
June 18, 2012 at 4:22 pm
Also I installed replication explorer and when reviewing my publisher, it states:
1) a subscription to a transactional publication has not been synchronized within the retention period threshold.
June 19, 2012 at 7:30 am
Might be worth trying to reinitialise the subscription, marking the option for 'Use a new snapshot', and tick the box to 'Generate a new snapshot now'
Cheers
Vultar
June 20, 2012 at 8:57 am
I'm not sure what replication explorer is, but you can clearly see the status in Replication Monitor that comes with SSMS.
otherwise, agree with vultar that it sounds like it needs to be reinitialized.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply