Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Duplicating Database onto DR site Expand / Collapse
Author
Message
Posted Tuesday, January 10, 2012 10:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 11, 2013 7:59 AM
Points: 3, Visits: 16
Hello Everybody,
I am not sure immediately-updating replication is my solution .....hence the subject

We have a high profile application that has a front-end application server with SQL2008R2 database on a 3-node windows 2008 cluster. Although the database cluster / actual database is up/available and the application server is available - we want the high-profile board members to be directed to DR site in case of network issues - and they cant reach the application/database.

I have initiated replication with the transaction logs sent across every 10 minutes, and manual redirection from application server to DR site - but the requirement is more like 'No manual intervention for failover or failback' and if necessary duplicate application server at DR site.

I guess the issue is more like the database being located in primary and DR site being completely in sync at all times and syncing back even after a 1-2 hour downtime on one side.

If there are 3rd party tools out there tat you have used that information will also be helpful. Thanks in advance.
sda33
Post #1233397
Posted Tuesday, January 10, 2012 11:14 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, February 01, 2012 3:57 AM
Points: 91, Visits: 125
Why dont you go with database mirroring?
Post #1233414
Posted Wednesday, January 11, 2012 8:08 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 11, 2013 7:59 AM
Points: 3, Visits: 16
The principal role needs to be taken over without manual intervention by the (DR)mirrored database - although the original principal database is up from a SQL perspective and yet unreachabe for the application server or the web-frontend used by the board members.

A variation of Merge replication may be the solution - but the material I am reading is not clear enough.
Post #1234008
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse