Hi Stephanie,

 

My current employer has been extremely disappointed by the data tiers failover procedure with SQL server mirroring for TFS 2008 (http://msdn.microsoft.com/en-us/library/aa980627(VS.80).aspx">http://msdn.microsoft.com/en-us/library/aa980627(VS.80).aspx) .

 

We are curious if TFS2010 will improve in this area and will natively support automated failover, leveraging a SQL mirror and its witness in a high availability scenario so that in case teh primary data server dies, we do not experience downtime.