Microsoft KB Archive/919156

= FIX: The Visual Studio 2005 Team Foundation Server database may become corrupted when you upgrade a Visual Studio 2005 Team Foundation Server installation =

Article ID: 919156

Article Last Modified on 7/5/2007

-

APPLIES TO


 * Microsoft Visual Studio 2005 Team Foundation Server

-



SYMPTOMS
When you upgrade a Microsoft Visual Studio 2005 Team Foundation Server installation at the same time as Internet Information Services (IIS) and Microsoft SQL Server 2005 are processing Team Foundation Server client requests, the Team Foundation Server database may become corrupted. This corruption may cause unpredictable errors and data loss.

Version 2 of this update addresses the following problems with version 1:
 * Team Foundation Server Service Pack 1 (SP1) and Team Foundation Server SP1 hotfixes do not install on a SQL Server clustered data tier.
 * Team Foundation Server SP1 and Team Foundation Server SP1 hotfixes may not install because issues connecting to the Team Foundation Server databases occur.
 * Team Foundation Server databases may be left in single-user mode after installation fails for Team Foundation Server SP1 or for Team Foundation Server hotfixes.



CAUSE
Team Foundation Server is a client/server application. Client requests are processed by using Web services that run in IIS. These Web services use data that is stored in SQL Server 2005. If an update operation is not finished, Team Foundation Server may be in an unknown state. This may cause data corruption.



RESOLUTION
To resolve this problem, download and install the following update. The update can be applied to both the release version of Visual Studio 2005 Team Foundation Server and Visual Studio 2005 Team Foundation Server SP1.We recommend that you apply version 2 of this update before you try any additional servicing operations. Servicing operations in this context can be characterized as any of the following:
 * Product repair
 * Visual Studio 2005 Team Foundation Server SP1 installation or uninstallation
 * Visual Studio 2005 Team Foundation Server hotfix installation or uninstallation

Update information
The following file is available for download from the Microsoft Download Center:

Download the VS80-KB919156-v2-X86.exe package now.

For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to obtain Microsoft support files from online services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.

Prerequisites
You must have Team Foundation Server installed before you install this update.

Restart requirement
You do not have to restart the computer after you install this update.

File information
The English version of this update has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



MORE INFORMATION
This update adds functionality to stop the Team Foundation Server services and puts IIS and SQL Server 2005 into a state in which client requests are refused. This update also provides functionality that returns the system to a state in which the system can process client requests again. No additional action is required after you apply this update. All Team Foundation Server updates that you apply after this update will use this new functionality. This release (version 2) replaces the first release of this update. Version 1 of this update is no longer available.

Notes
 * You must apply this update before you install Visual Studio 2005 Team Foundation Server SP1.
 * If you have configured Team Foundation Server to use a SQL cluster for the data tier, you must apply version 2 of this update. If you do not, Team Foundation Server SP1 will not install. You must install this general distribution release (GDR) and Team Foundation Server SP1 on the active node in the SQL cluster, and the Team Foundation Server (databases) installation must appear in the Add Or Remove Programs item in Control Panel on the computer.
 * We recommend that you apply version 2 of this update before you perform the next servicing operation on one of the server tiers. Servicing operations include the following:
 * Product repair
 * Visual Studio 2005 Team Foundation Server SP1 installation or uninstallation
 * Visual Studio 2005 Team Foundation Server hotfix installation or uninstallation
 * You only have to apply this update one time.
 * You can apply this update on both the release version of Team Foundation Server and Team Foundation Server SP1.
 * You do not have to uninstall version 1 of this update if it is already applied. You can apply version 1 and version 2 of this hotfix together. No problems will occur.
 * As soon as you apply version 2 of this update, you cannot uninstall either version 2 or version 1 of the update.

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

824684 Description of the standard terminology that is used to describe Microsoft software updates

Additional query words: VSTF TFS data corruption

Keywords: atdownload kbsample kbfile kbinfo kbfix kbbug kbqfe kbpubtypekc KB919156

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.