The versions of SQL Server databases do not match
The information in this article applies to:
Visual Studio Team Foundation Server 2010
Windows Server 2003 and Windows Server 2008
SQL Server 2008
Data-tier server
Team Foundation Server Complete Health check
Team Foundation Server Framework Health Check
The Best Practices Analyzer tool for Team Foundation Server checks the SQL Server version of the configuration database for Team Foundation Server (Tfs_Configuration) and the version of the database for each team project collection (Tfs_CollectionName).
An error appears if the versions do not match.
- SQL Database {0} has an incorrect version number
The most likely cause for this error is that you have installed one or more service packs for SQL Server 2008 on one or more data-tier servers but not on all data-tier servers. Or, you may have restored a database that is not the correct version for that database.
To resolve this error, you should first determine how the mismatched versions occurred. If the error condition occurred because a database backup was restored from a previously imported version, you must restore the over-written database. If the error condition occurred because service packs are missing, you must update the servers with the missing service packs.
For more information, see the following pages on the Microsoft Web site:
Additional Information in the Tree Report
The tool logs the information that it gathers in two places in the tree report. The tool logs information about Tfs_Configuration under the named data-tier server, and the tool logs information about Tfs_CollectionName under the named database for the project collection.
You can locate the node for the named data-tier server node by expanding Team Foundation Server Complete Health Check and then expanding Team Foundation Server Data Tiers.
You can locate the node for the named database for the project collection by expanding Team Foundation Server Complete Health Check, expanding Team Foundation Server, expanding Team Project Collections, expanding the named collection, and then expanding Database Info.