You can use the Diagnose command to discover any software update mismatches between the application tier and the databases for Visual Studio Team Foundation Server. To operate correctly, the application tier and the databases must have the same software updates applied. If a software update mismatch occurs, you can use this command to identify the problem and receive information about what additional steps you must take to address the issues.
If the Diagnose command finds that a software update has been applied to the application tier but not to one or more databases for Team Foundation Server, you can use the Updates command to attempt to automatically apply the update to the databases. For more information, see Updates Command. However, if a software update has been applied to one or more of the databases but not to the application tier, you cannot use the Updates command to apply that update to the application tier. The Updates command applies updates only to the databases. To address the problem of a missing update on the application tier, you must manually apply the update to the application tier.
To use the Diagnose command, you must be a member of the Team Foundation Administrators group on the application-tier server for Team Foundation and a member of the sysadmin group in SQL Server on the data-tier server for Team Foundation. For more information, see Team Foundation Server Permissions.
Even if you are logged on with administrative credentials, you must open an elevated Command Prompt to perform this function on a server that is running Windows Server 2008. To open an elevated Command Prompt, click Start, right-click Command Prompt, and then click Run as Administrator. For more information, see the Microsoft Web site.
The following example shows how to run the Diagnose command to determine whether the same software updates have been applied to the databases and the application tier.