• Hi all

    Has anyone used it to complement clustering? is it possible?

    We run a number of SQL clusters at prod data centres, they are SAN connected and also use SAN mirroring to the DR data centre. On top of this we also log-ship databases via a tivoli storage agent to the DR server(s). Has anyone used or considered database mirroring to complement/replace log-shipping within a clustered scenario in prod?

    This scenario is typical in the Oracle world, where the prod site runs RAC and uses data guard (where I see SQL Server's data mirroring competing as a technology).

    Thoughts/comments?

    Cheers

    Ck


    Chris Kempster
    www.chriskempster.com
    Author of "SQL Server Backup, Recovery & Troubleshooting"
    Author of "SQL Server 2k for the Oracle DBA"