SQL Server Performance

Mirroring vs. Log-Shipping and Clustering (to connect two datacentres)

Discussion in 'SQL Server 2005 Clustering' started by wakko303, Apr 11, 2008.

  1. wakko303 New Member

    Hi All,
    Could you give an idea about the following design requirement:
    Right now we are planning to connect two data-centre (WEST & EAST).
    Everthing will be build from scratch.
    Both data-centres are running a 2-node single instance sql 2005 A/P cluster.
    The instances host critical reporting data (emergency).
    The WEST must provide/transfer his data to the East.
    A minor delay in the EAST is acceptable. Which technology would you recommend to transfer data from the WEST to EAST?

    a) Log-Shipping (I think the problem is that the target is in a recovery mode and not accessable for users, but there should be snaphsot mode for Read-Only)I also heard that Log-shipping will be not supported anymore in future releases.

    b) Database-mirroring (What will happen, if the Principal fails in the main datacentre?)

    Thanks for ideas
  2. jagblue New Member

    Hi
    I hope this artical will help you to understand mirroring
    http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx
    There are three different modes in Mirroring1) High Availability
    2) High Protection3) High Performance (Only for Enterprise Edition)
    Look options for all 3 modes and try to apply best one suit for your requirement
    Thanks
  3. wakko303 New Member

  4. ghemant Moderator

    Hi,
    DB Mirroring will give you automatic fail-over, and this is the advantage over Log Shipping. Refer http://technet.microsoft.com/en-us/magazine/cc160992.aspx

Share This Page