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

Database Mirroring vs MS Sync Framework Expand / Collapse
Author
Message
Posted Monday, March 17, 2014 1:03 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 8, 2014 8:50 AM
Points: 27, Visits: 74
Hi,
Someone can told me if MS Sync framework can be use for a standby database instead of SQL Server database MIrroring ?

regards
C
Post #1551879
Posted Monday, March 17, 2014 3:40 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 2:51 PM
Points: 1,194, Visits: 2,213
It depends. What's the actual requirement ? Is it providing High Availability\Disaster Recovery or for providing data to the remote disconnected clients ?

--
SQLBuddy
Post #1551944
Posted Monday, March 17, 2014 4:35 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 8, 2014 8:50 AM
Points: 27, Visits: 74
Hi,
the objective is to have HA/disater/recovery scenario.

regards
C
Post #1551957
Posted Monday, March 17, 2014 6:08 PM This worked for the OP Answer marked as solution
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 2:51 PM
Points: 1,194, Visits: 2,213
If it's for High Availability\Disaster Recovery purpose, use DB Mirroring.

MS Synch is used when there are distributed\mobile clients.

--

SQLBuddy
Post #1551966
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse