Now that Microsoft SQL Server 2005 SP1 is out, I’ve been hearing from people asking about installing it on servers that support Team Foundation Server.
While the service pack is not a requirement for Team Foundation Server at this time, it is highly recommended for both current deployments and new deployments as it contains a number of fixes and performance enhancements. In addition, for new deployments, the service pack includes the required SQL Server hotfix mentioned in the Team Foundation Installation Guide.
As always, you should back up your data before installing the service pack and review the accompanying readme. If you are installing in a cluster, be sure to read the special instructions included in the readme.
If you are updating Microsoft SQL Server 2005 Enterprise Edition, the Team Foundation data cube perspectives are not fully generated, but we will supply a fix for that soon.