You can use the Updates command to install any software updates that are missing from the databases for Visual Studio Team Foundation Server (TFS). In most cases, software update mismatches will not occur, because updates are usually applied to the entire deployment. To operate correctly, the application tier and the databases must have the same software updates applied. If a software update mismatch occurs where the databases are missing one or more updates that have been applied to the application tier, you can use the Updates command to attempt to automatically apply the missing updates to the databases.
The Updates command applies updates only to the databases. If a software update mismatch occurs where the databases have a software update that has not been applied to the application tier, you must manually apply that update to the application tier. For more information about how to determine whether a software update mismatch might have occurred, see Diagnose Command.
To use the Updates 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.
You use the Updates command to attempt to automatically apply to the TFS databases any software updates that have already been applied to the application tier. When you run this command, messages will inform you about the status of the update attempts. Update jobs will be queued for any databases that are missing the updates. These databases might include the configuration database, the warehouse database, and all databases for team project collections. If one or more jobs cannot complete, error messages will specify which databases could not be updated and provide more information, if any is available.
The following example shows how to run the Updates command to apply to the databases for Team Foundation Server any software updates that have already been applied to the application tier.