Post reply

Best Fail-Over/Disaster Recover Architecture

  • January 30, 2009 at 4:26 pm

    #130503

    Any recommendations/feedback on SQL2K5 Server recovery architectures? Cluster, Standby? What do you use and why?

  • January 30, 2009 at 5:16 pm

    #935915

    What do you need to do?

    Architecture is very much dependent upon the results you are trying to achieve.


    Shamless self promotion - read my blog http://sirsql.net

  • January 31, 2009 at 4:48 am

    #935976

    I think the real question is, how much can you afford to spend?

    The entry level DR features of SQL Server like log-shipping work ok, then database-mirroring is worth looking at.

    If your budget will stretch far enough, a geographically-dispersed cluster running on a mirrored SAN is pretty much the Rolls-Royce of DR \ Contingency architecture.

    My experience is that with decent kit, the failover time is in the region of a few seconds, and if you have your servers in different geographic locations, you can recover service from complete site loss before anyone has actually noticed.

    That said, for my money the best and cheapest DR solution is always a well tested backup regime.

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

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