Team foundation server deployment in geographically dispersed location

Question

Hi, one of my requirement is to install TFS 2012 in an environment where 2 offices are geographically located in two different continents. Wiz. one in India and other is in US, although the offices are connected by Internet/VPN tunnel there are times when the network fails between these two locations.

We need to setup a TFS in such a way that even in the case the network fails the clients are able to connect and work,please note that there is a time diff of more than 12 hrs between the offices. Using the team foundation proxy will not really solve the problem in case of outage..

Two different SQL instances with replication enabled (master - slave) may cause data loss when the replication occurs after the network outage..

any idea how to design this ? any help or pointers will be appreciated.

Thanks

---

Thanks, Saurabh

Answer 1

You can take a look at Always On in SQL 2012 http://msdn.microsoft.com/en-us/library/ff877884%28v=SQL.110%29.aspx

---

Thanks, Sethu Srinivasan [MSFT] SQL Server http://blogs.msdn.com/sqlagent -------------------------------------------------------------------------------- This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.

Answer 2

Hi Saurabh,

You can try Merge Replication, when the Subscribers are online again after offline, they will synchronize changes with the Publisher and other Subscribers. For more detail information, please refer to the following link:

http://msdn.microsoft.com/en-us/library/ms152746.aspx

---

Allen Li
TechNet Community Support