TFS Migration to SP1 Lessons
Following couple of points to have in mind when migrating Team Foundation Server to SP1 based on problems and solutions we encounter:
- The first step is to install the prerequisite (KB919156). Make sure that the installation is finished successfully, displaying the summary/finish window. What sometimes happens is that the installation fails and the installation form closes without any notice. When you'll check the databases you'll see that some of the databases are in SINGLE_USER mode. To continue the installation, change all the databases accept the STS_CONFIG_TFS (and probably the reporting services databases- I'm not sure if about them) to SINGLE_USER mode and start the KB installation again. (If you change the STS_CONFIG_TFS database to SINGLE_USER mode you get an error message indicating that you should re-install the WSS. Don't do that! ;) ). Another thing that could happen is that after the upgrade finishes, the KB installation won't be able to change the databases back to MULTI_USER mode and you would get a Retry option but the installation will not crash. What you should do is change the restrict access of the databases that are still in the SINGLE_USER to MULTI_USER manually. You might need to stop some of the SQL services to be able to change them. After a few refreshes and retries you will be done with the KB installation.
- Next step is the SP1 installation. Make sure you don't have the beta version. You might encounter the same syndrome during this upgrade as you did in the KB919156 upgrade. Make sure you get the last windows indicating a successful installation. Make sure the databases don't get stuck in SINGLE_USER mode or in MULTI_USER mode
- Last thing is to make sure that the databases were updated. You can use the repository table in the VersionControl database as some indication to the success of the upgrade.
Just in case you still run into some problems after the upgrade process, here's post provided by a colleague of mine which might help you.
Good Luck,
Roy