which one is better for High Avaliability

  • Hi everyone..

    log shipping, Replication,Mirroring which one is better for High avaliability? and in now a days companies which one prefer? plz give reply....

  • it depends on the SLA for "high available".

    Of course, mirroring can be configured to be synchronous, but is depricated for future versions, because Always On is the "new" kid in town.

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • Replication isn't really high availability and is probably the most complicated to maintain.

  • Depends on the requirements and constraints. There's no one that's best always.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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