Post reply

Odd Behaviour Transactional Rep

  • May 25, 2005 at 8:33 am

    #102550

    Hi,

    I've had transactional replication running on a test environment for a while...no problems.

    Recently, I changed the Publisher and the Subscriber  around. Simply reapplying the script but changing the Publisher reference....no problem.

    Again recently I have noticed that no records are replicating. But I am not getting any errors. I make a change on the Publisher but it does not appear on the subscriber  a minute later as per the schedule. The distribution agent appears to be distributing.....I have nothing to really go-on.

    Any one got any thoughts?

    Are the transactions being blocked in any way?

    Many Thanks...Graeme

     

     

  • May 26, 2005 at 2:57 am

    #561153

    Hi

    Enable replication agents for loggin to output files in SQL Server and attach the output file in a post.

    To enable this look at this "how to":

    http://support.microsoft.com/default.aspx?scid=kb;en-us;312292&Product=sql2k

     

  • May 26, 2005 at 3:02 am

    #561154

    Thanks for that!

    I will have a look.

    Cheers..Graeme

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

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