Post reply

How to check data synchronization in tables both at Publisher and subscriber.

  • November 28, 2011 at 12:43 am

    #246760

    We have configured transactional replication and We want to run a query that Will tell us the synchronization of dat at the publisher and subscriber. I want result set to be ( in case of difference) mailed through database mail.

    My Question is that, is there any built in procedure to achieve this purpose. Or should I write my own query.

    Please help me or refer me a better approach to achieve this.

    Thank

    Azhar

  • November 28, 2011 at 12:59 am

    #1413263

    Replication Monitor would be a good start.

    Monitoring How-to Topics (Replication)

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

  • November 28, 2011 at 1:20 am

    #1413266

    azhar.iqbal499 (11/28/2011)

    We have configured transactional replication and We want to run a query that Will tell us the synchronization of dat at the publisher and subscriber. I want result set to be ( in case of difference) mailed through database mail.

    My Question is that, is there any built in procedure to achieve this purpose. Or should I write my own query.

    Please help me or refer me a better approach to achieve this.

    Thank

    Azhar

    Yes, there are built in procedures such as sp_publication_validation to achieve this purpose.

    Email alert from a SQL Agent job should be possible. But now I don't remember the exacts steps to configure it.

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

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