Post reply

How to find SQl Server Replication Frequency (Tran Replication)

  • November 12, 2010 at 4:10 am

    #231241

    Hi,

    In 2005, in my set up , some one had established Transanction replication setup, and he left the organisation. When i came in to picture, I coulnt find the answers for the below points

    1. I can find the publisher, but coulnt find the distributor for that.

    2. I couldnt find the snapshot duration, is data transfer occur daily or every 1 hr etc

    3. Distributor is not in my prod server(Puyblisher) I couldnt find the distributor , but i got info tht its in different server. how to find it?

    Thank you

    Hemadribabu

  • November 15, 2010 at 8:11 am

    #1250750

    If you open the Replication monitor and look at the properties, you can get the answers to two of your questions. You can see the Distributor name, Subscriber name.

    Snapshot agent is a job. You can check the job schedule to find the duration of your snapshot agent.

    -Roy

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

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