Recently I've been working on SQL mirroring with TFS and concentrating on worst case scenarios, when the principle data tier goes down. The whole point of mirrors with TFS, as I understand it, is high availability. With regards to setting up mirroring