Determining the success and frequency of Replication

• Jay Bee-249994

  SSCrazy

  Points: 2393

  More actions

  May 4, 2006 at 4:51 am

  #90047

  Hi all, firstly excuse my ignorance if these are basic issues, been a long time since I studied Replication.

  I'm on a greenfield site and inherited 2 databases of the same name, structure, and similar sizes, but on different servers, on this site and on a remote one.

  My question now is how do I determine IF the remote server is successfully replicating, and how often, given that the copy on subscribing server (local) is only 7.5Gb? I hope to be able to explain the disparity between the

  Any help appreciated,

  Jaybee.

• Paul Ibison

  SSCertifiable

  Points: 5303

  More actions

  May 4, 2006 at 6:27 am

  #635893

  For the replication frequency, please look at the schedule of the synchronizing agent (merge or distribution, depending on your type of replication).

  The agent history will tell you if there are any errors.

    Cheers,

             Paul Ibison SQL Server MVP, http://www.replicationanswers.com

   

   

  
  Paul Ibison
  Paul.Ibison@replicationanswers.com