Synchronizing in Transactional Replication

  • Hi,

    I have a question in transactional replication.How do you check the synchronization between publisher and subscriber in transactional replication?

    And also what is the maximum size of the database on which we can do transactional replication.

    Any help is appreciated.

    Thanks,

    Sree

    Thanks,
    SR

  • This was removed by the editor as SPAM

  • Hi Sree,

     

    You can check jobs history in your Publisher server. Using your Enterprise Manager go to Management -> Jobs and check jobs with REPL in Category column. Also check Agents history in your Replication Monitor->Agents->Log Reader Agents and Distribution Agents for any failure.

     

    Also, if you have any test table you could input some data into it, and check after few second on your subscriber to see if those data are replicated.

     

    Size of database doesn’t matter; we are replicating 35 GB without problem. It depends however, on the current load and your server performance.

     

    Regards,

    Igor

  • Thanks for your response Igor.I appreciate your help.

    Sree

    Thanks,
    SR

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

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