William Bartholomew

I decided that I’d put off the upgrade to TFS Service Pack 1 for long enough and did the upgrade on our production server yesterday.

The good news is that it went very smoothly and the only hiccup I encountered was actually related to installing SQL Server Service Pack 2 (which we chose to do at the same time). The problem was simply that there wasn’t enough space available on the system drive to complete the installation.

For those of you that are interested the process I followed is:

1. Take a snapshot of the virtual machine.
2. Stop IIS (iisreset /stop).
3. Perform a full backup of all of the SQL Server databases.
4. Start IIS (iisreset /start)
5. Install Windows Powershell (required by the TFS Best Practice Analyzer).
6. Run the TFS Best Practices Analyzer.
7. Install the Quiescing GDR on the TFS server and the TFS proxy.
8. Install TFS Service Pack 1 on the TFS server.
9. Install TFS Service Pack 1 on each of the build machines.
10. Install TFS Service Pack 1 on the TFS proxy.
11. Test.

I also performed a couple of extra steps:

1. Install SQL Server Service Pack 2.
2. Install Team System Web Access.
3. Modified the Work Item Changed XSL to link to Team System Web Access.
4. Install hotfixes for the 2 issues we’ve come across.

1. FIX: Error message when you perform a merge operation in Visual Studio 2005 Team Foundation Server: “TF14087: Cannot undelete because not all of the deletion is being undeleted”.
2. FIX: When the Microsoft.TeamFoundation.VersionControl.Adapter adapter processes a changeset, the adapter may fail in Visual Studio 2005 Team Foundation Server.

1. Because we’re using a single server configuration we’re testing whether there will be a performance improvement by restricting SQL Server’s memory to ensure that there is memory left for the application “tier” and the OS.