Post reply

monitoring replication from outside

  • September 13, 2005 at 4:54 pm

    #187585

    Hello,

    This might be a simple answer for you but is giving me a hard time. Any help would be appreciated.

    What query or stored procedure can be executed to return if the replication (on the server) is happening or not?

    My application is accessing an MSSQL database which has replication running. Need to provide a boolean indicator to show if the replication is happening in the background. FYI: application is written in Delphi7 and is using ADO components for talking to the server.

    Thanks for sharing your knowledge

     

  • September 13, 2005 at 5:25 pm

    #589543

    It all depends what part of replication is working!

    If your wanting to know if the transactions have replicated to the Subscriber & vice versa, then you can intergoate some of the system tables in the MSDB Database as well as the System Tables in the Database that is configured for Replication. I can't remember wich tables but it won't be difficult to find.

    Kindest Regards,

  • September 14, 2005 at 10:42 am

    #589815

    Not sure what you mean by 'what part of replication'. We are using TRANSACTIONAL REPLICATION.

    All this replication stuff is new for me.  Could you guide me for what table or fields to look into?

    Thanks for helping me with this.

  • September 14, 2005 at 7:22 pm

    #589983

    If you want to find out replication info look in the SYSPUBLICATIONS & SYSSUBSCRIPTIONS tables in the user database.

    However, if you want to check on the status of Replication, you will have to look in the MSDB Database in the SYSJOBS table.

    Kindest Regards,

  • September 15, 2005 at 9:43 am

    #590198

    You could write a script to get counts of your publisher tables and subscription tables and check that the counts match

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

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