Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am searching for an option to synchronize data between production server and backup server automatically. Does somebody know a method, how I can do this:

  • if I delete, insert or update a record it should update it should do the same action for the backup server

  • if I select some entries it should select it from the primary server

  • if the primary server is not available it should select, insert, update and delete on the backup server
  • if the backup server is available again, it should write the data back to the primary sql server
share|improve this question

migrated from stackoverflow.com Jun 5 '13 at 18:27

This question came from our site for professional and enthusiast programmers.

    
We've used XOSoft's WanSync HA for this scenario - see rdtsolutions.com/pdf/wansyncha_data.pdf. However, if you don't have specific expertise in this area, and you are building and designing a production database system that people rely upon, I'd seriously consider getting additional help. –  dash Jun 5 '13 at 8:04
1  
@mjeOsX what version of sql server are you using ? –  Kin Jun 5 '13 at 18:31
1  
Is the goal fault tolerance against a single point of hardware failure, duplication of data in two locations, or both? –  Jon Seigel Jun 5 '13 at 18:40
    
If you have SQL Server Standard edition or higher and version 2008 or higher (you haven't specified in your question) then Database Mirroring might be a solution, but note that it is a feature that will be removed in some future version of SQL Server. THe replacement feature is AlwaysOn but that requires SQL Server 2012 Standard edition or higher and also requires Enterprise Edition of Windows Server 2008 or STandard Edition or higher of Windows Server 2012. –  Greenstone Walker Jun 6 '13 at 22:55

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.