Post reply

Transactional replication using pull subscription alerts

  • May 24, 2012 at 9:15 pm

    #274440

    Hi ,

    I had setup transactional replication on three servers A, B and C. Server A and B are Publishers and Server C is subscriber.

    All of the three servers have same configuration.

    Server A, B, C -- SQL Server 2008 r2 Ent 64 bit edition (RTM) on windows server 2008 r2 ent edition SP1 64 bit

    I have two publications on server A and two publications on server B, four subscriptions on server C.The replication is continous. I mean no schedules.

    I need to setup alerts on the replication. If the replication breaks down for any reason i need to get an alert stating that the replication is down.

    Currently i don't have any alerts setup.

    Can you please assist me in setting up the alerts.

    Thank You,

  • May 25, 2012 at 7:08 am

    #1493130

    if your talking about setting standard replication alert messages then use the built in replication alerts. These cover most of the usual error issues such as agent failure that kind of thing.

    http://msdn.microsoft.com/en-us/library/ms152496.aspx

  • May 25, 2012 at 8:30 am

    #1493199

    Just check this link [/url], could be useful for you.

    M&M

  • May 25, 2012 at 8:42 pm

    #1493444

    Hi,

    i will try your options.

    Thank you,

  • June 4, 2012 at 4:41 pm

    #1496819

    Hi moinudheen,

    I had checked your post. The Jobs are working well.

    Thank You very much for your help.

    I did not test for the alert. i will wait and see if the alerts are fired when the replication breaks.

    Thank You,

  • June 4, 2012 at 4:42 pm

    #1496820

    Hi Reevej,

    Thank You very much for your help. I checked Mohammed's link. His link seems to be exactly what i need.

    Thank You,

  • June 4, 2012 at 10:41 pm

    #1496882

    sql2k8 (6/4/2012)

    Hi moinudheen,

    I had checked your post. The Jobs are working well.

    Thank You very much for your help.

    I did not test for the alert. i will wait and see if the alerts are fired when the replication breaks.

    Thank You,

    Thanks for the update. Nice to know we could help 🙂

    M&M

Viewing 7 posts - 1 through 6 (of 6 total)

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