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

Article translations Article translations
Article ID: 919156 - View products that this article applies to.
Expand all | Collapse all

On This Page

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:

Collapse this imageExpand this image
Download
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.
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Tfsquiesce.exe8.0.50727.88694,20825 May 20071:48x86

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" 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

Properties

Article ID: 919156 - Last Review: October 9, 2011 - Revision: 5.0
APPLIES TO
  • Microsoft Visual Studio 2005 Team Foundation Server
Keywords: 
atdownload kbsample kbfile kbinfo kbfix kbbug kbqfe KB919156

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com