Post reply

Database mirroring & replication.

  • December 22, 2006 at 11:57 am

    #171414

    Hi,

    We have four servers running SQL Server 2005. Two out of four are production servers.

    So I would like to hear from you folks is to see if there are any drawbacks with the following setup.

    HA Solution: SQL SRV 1 <-- DB Mirroring --> SQL SRV 3 <-- DB Mirroring --> SQL SRV 2

    &

    DR Solution: SQL SRV 1 <-- Replication --> SQL SRV 4 <-- Replication --> SQL SRV 2

    Thanks.

  • December 22, 2006 at 4:22 pm

    #679860

    I don't see any problem with solution but I don't prefer SQL server replication for DR.

    I will prefer Log shipping over replication if the db size above 50 GB or high transaction db.

     

     

    MohammedU
    Microsoft SQL Server MVP

  • December 29, 2006 at 8:12 am

    #680507

    Thank you Mohammed, our databases sizes are not that big and they are not high transaction db either.

  • December 29, 2006 at 9:12 am

    #680528

    The main issue is *in my opinion* if you need to interact with the redundant servers. Mirroring will *not* let you, unless you create db snapshots. Replication will. On the other hand replication will impose more strain on system resources than mirroring

    -Good Luck


    * Noel

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

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