SQL Server Replication

  • Chandra Sekhara Vyas Dhara

    SSChampion

    Points: 10207

    Comments posted to this topic are about the item SQL Server Replication

  • This was removed by the editor as SPAM

  • Ed Wagner

    SSC Guru

    Points: 286950

    Thanks for a question that's outside my comfort zone.

  • PHYData DBA

    SSCertifiable

    Points: 7541

    Great question.

    Not sure why so many people selected distribution agent and not log reader.

  • Rob Schripsema

    SSCertifiable

    Points: 7469

    Replication often feels like a mysterious, black-magic operation that is too intimidating to understand. Your question highlights the fact that it is really just a bunch of tasks (agents) and transient data tables doing normal SQL stuff. The beauty is that they all dance together, usually in step with each other, but still just putting one foot in front of the other. It only LOOKS complicated; once you understand the functions of the various agents, not so complicated.

    Good question.

    Rob Schripsema
    Propack, Inc.

  • Revenant

    SSC-Forever

    Points: 42468

    Very nice. Thanks, Vyas!

  • TomThomson

    SSC Guru

    Points: 104707

    Nice straightforward question.

    For something over 6 years transactional replication (on sql 2000) was a critical component of disaster recovery for systems scattered around the world that I was responsible for. So I found this one easy, even now 6 years after I ceased to be involved with that (although I have looked to see any changes to transactional replication in new SQL Server releases). But questions about other sorts of replication than transactional would have me scrabbling for the documentation - merge replication seems to me like black magic.

    Tom

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the question Vyas.

  • Koen Verbeeck

    SSC Guru

    Points: 258859

    Nice question, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Bhushan Kulkarni

    SSCrazy

    Points: 2829

    Refreshed replication knowledge

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

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