On Cloud Computing, Integration Technology, Mobility, RFID, ERP etc...
Sr, Program Manager at Microsoft and MBA from UNC Chapel Hill.My small world includes my beautiful wife Swati and our awesome twin boyz Arni and Abhi.
Failover is a big concern for everyone using Team Foundation Server. What happens if the server hosting Data Tier of Team Foundation Server crashes? How can we get the whole system back up and running in least amount of time? There are various solutions to this problem. Traditionally we have recommended using Clustering for maximum availability. Clustering is a great solution, as it provides automatic failover that is transparent to end users. Another option is to use backup and restore mechanism of SQL Server. In this case users can take combination of Full and incremental backup of the Data Tier and if there is a failover of primary server you can easily recover the TFS Data Tier using the backed up data. This could be a very time consuming process.
Clustering provides automatic failover; Backup/restore provides long lead time recovering of server. SQL Mirroring can be used as a solution in between both of these options. SQL Mirroring provides warm standby but TFS does not support automatic failover with mirroring. Few manual steps need to be executed when the primary server fails with mirroring in TFS. We are working on a White paper to provide detailed steps on using SQL Mirroring for failover scenarios in TFS. We should have it ready within few weeks for everyone to use. Till then following are the high level steps required to use mirroring.
The process of configuring a VSTF deployment for mirroring can be defined in following steps
More detailed Mirroring steps should be up on MSDN in next few weeks. I will keep all of you updated when that happens.
Its been two months since I joined Microsoft. These two months have been hectic, lots to learn, lots to understand and lot more to catch up. I have learnt a lot in every area from technology to process to management in this short period of time. The most important point I have noticed is, management’s commitment to customer satisfaction. Customer Focus is one theme that drives product designs and development at Microsoft. We have processes in place which help us take constant feedback from customers. One way of doing that is through blogs.
Looking at this level of customer focus across the organization I want to do my part. Here are two commitments from me to all our customers
I have been spending lot of time trying to catch up with all the functionality and understanding philosophy behind TFS. I still don’t know everything, but now I know people who know everything. So if you guys want to know anything about TFS in general and Admin/Ops in specific please please please feel free to shoot an email or leave a comment. I promise I will get back to you ASAP.