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
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
Hi I found the following concerning Clustering & Mirroring: http://msdn2.microsoft.com/en-us/library/ms191309.aspx
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