Hi,

Ive got an instance running replication to another instance on the same server. Ive just completed an archiving query that took 10 to run. Ive tested replication by changeing a value in a field and checking if it propogated to the subscriber. It hasnt, but im wondering if the replication is taking a long time to catch up or if its just broken (it was running ok before I initiated the 10 hour query). Is there a way to check if its still running?  The replication monitor confuses me!

Thanks,

Zoe

 not sure what is the confusion in replication monitor - it will easy tell you whether replication is working or not?

if you do not prefer that - your other option is check the history of the sql agent jobs.

from what you described, it appear like you have transactional replication and if so, you should have three jobs for this publication 1.snapshot job, 2 distrbutor job and 3.log read job.

ideally, - depending on the configuration of replication - your distributor and log read jobs should be running constantly or very often schedule. so, in your sql server agent job - check the job history of these two jobs(distributor job could be on the subscriber if the replication is pull).. and the job history wil tell how replication is working,...

other option is on the publisher -- under replication - local publisger - right click on the publication and view synchronization status and on the sunscriber - check the same and it should tell you any errors or report any issues...

Thanks!

Thats a great help. It looks like it is running, but its taking over 24 hours to catch up!

Is there anyway to look for the queued transaactions? (i.e the transactions waiting to be published at the subscriber)?

Thanks,

Zoe

You may refer the below script and use to get the pending transactions:

https://gallery.technet.microsoft.com/T-SQL-Script-Replication-5e691953

You can launch the replication monitor and see the publisher properties.

from the properties information you can see more information. you will see red cross if broken.

also able to see if in sync or not.

here are some use ful links how to open replication monitor.

click here

click here