As I mentioned in my last post we are working on documentation on how to use SQL Mirroring with TFS. We have the draft white paper published today at http://blogs.msdn.com/vstsue/archive/2006/11/03/mirroring-the-team-foundation-data-tier-server.aspx.
Please let us know if you have any questions on the content in the paper.
One of our Program Managers, Sudhir Hasbe , has posted a draft of a whitepaper detailing how to use SQL