Monday, February 13, 2012 6:09 AM
Could someone please suggest me the most appropriate method of database clustering and synchronization. Please find belo a pictorial vie of our requirement.
Monday, February 13, 2012 1:15 PMAnswerer
I'm not sure I understand your topology correctly. In SQL Server clustering there is only ever a single copy of the database. Are you looking to use clustering or are you asking for something that will fit your diagram above?
Tuesday, February 14, 2012 6:46 AMModerator
If I understand you clearly, it looks you could use SQL Server 2008 R2 Database Mirroring.
Database mirroring is a primarily software solution for increasing database availability. Mirroring is implemented on a per-database basis and works only with databases that use the full recovery model.
Database mirroring maintains two copies of a single database that must reside on different server instances of SQL Server Database Engine. Typically, these server instances reside on computers in different locations. One server instance serves the database to clients (the principal server). The other instance acts as a hot or warm standby server (the mirror server), depending on the configuration and state of the mirroring session. When a database mirroring session is synchronized, database mirroring provides a hot standby server that supports rapid failover without a loss of data from committed transactions. When the session is not synchronized, the mirror server is typically available as a warm standby server (with possible data loss).
Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
- Marked As Answer by Maggie LuoMicrosoft Contingent Staff, Moderator Thursday, February 23, 2012 9:05 AM