Post reply

Need Help Setting Up Transactional Replication

  • September 10, 2015 at 6:46 am

    #320516

    I am new to SQL Server administration so please be kind.

    I have created a publication on SQL 2014 SP1/CU1 it is going to a distribution server also a SQL 2014 database. The subscriber is also SQL 2014 SP1/CU1. When I set it up there are no errors. I fire up Replication MGR and it looks good after the snapshot and distribution agent have been started. Again, no errors. When I do a tracer token the information gets to the distributer in 1 - 4 seconds but it never gets to the subscriber, the tracer token monitoring screen only shows pending for distributor to subscriber.

    I can upload the scripts used to create the publication and/or the subscription but am a little hesitant because of server names in the scripts.

    Thanks so much in advance for the help!!

  • September 11, 2015 at 9:18 am

    #1826033

    David,

    Maybe I missed it in your script but I don't see where you have set up a Distribution database.

  • September 11, 2015 at 10:51 am

    #1826077

    Thanks for the reply. I actually figured out the issue on my own. There was actually an error with the distribution database, it had a statuses with bad values status = 3 and it should only be values 0,1,2. I ended up dropping the distribution database and recreating it and then rebuilt replication and everything worked.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply