Currently, we are using TFS deployment on a single-server.

Due to 24 hour based development projects, new requirements for making this fault-tolerant and working with limited ??ardware??we want to do following setup while TFS is still running (may be we can bring it down for few hours):

• Configure another server with SQL Server and make both of them part of a clustered SQL Server.
• Install TFS on the newly created part of clustered server and make this a ??assive??TFS application.

Luis I appreciate your response, thanks, but that link didn't answer my immediate question.

so I think I didn't got the question sorry, but I think the only way to have complete avaliability would be with four servers, anyway.

Hiren:

The current high availablity solution for TFS involves a warm standby Application Tier and a "Failover" clustered Data Tier. TFS only supports very specific clustering configurations.Clustering must follow the process outlined here: "How to: Create a New SQL Server 2005 Failover Cluster" (http://go.microsoft.com/fwlink/?LinkId=57969). You need at least 3 servers for clustering - 1 Application Tier and 2 Data Tier. You might need to ask in a SQL forum if you can create a cluster from an existing SQL installation. I do not know the answer to that, but I suspect you will need to completely reinstall SQL and TFS on the cluster to make it work.

Wendell