为什么我不能将 TFS 附加到已正确还原到 SQL Server(我认为)的项目集合? [英] Why can't I attach TFS to a Project Collection that was restored to SQL Server (I think) correctly?

问题描述

我们尝试将 TFS 项目集合从一台 TFS 2010 服务器移动到另一台服务器.

1. 在源服务器上的 TFS 控制台中分离集合
2. 在 SQL Server 2008 Standard Edition 中备份集合 Tfs_DefaultCollection
3. DBA 将集合还原到新数据库 Tfs_MyCollection 到 SQL Server 2008 Enterprise, R2，目标 TFS 服务器使用的实例.
4. TFS 管理员尝试连接到目标服务器.

TFS 管理员收到以下错误消息.

<块引用>

TF254078:在以下实例上找不到可附加的数据库SQL Server 的名称:MyServerName.验证服务器的名称并且实例的名称是正确的，并且数据库是使用 Team Foundation 中的 detach 命令正确分离管理控制台.

我认为我们不需要在目标服务器中准备数据库实例，因为它已经包含一个 TFS 项目集合.我认为升级 SQL Server 版本是可以接受的.

我的假设有效吗?无法连接到新 TFS 服务器的原因可能是什么?

顺便说一句，我最初在 ServerFault 上创建了这篇文章 Serverfault 中的镜像，但它在那里引起了很少的兴趣.

解决方案

确保 TFS 服务级别和 SQL 服务器版本都与之前的服务器匹配.
您可以使用 SQL Management Studio > Databases > Tfs_Configuration 或 Tfs_DefaultCollection 验证此信息> 属性 > 扩展属性

注意这些属性:

<前>TFS_PRODUCT_VERSION 10.0.40219.1TFS_SCHEMA_VERSION Microsoft Team Foundation Server 2010 (SP1)TFS_SERVICE_LEVEL Tfs2010.SP1.KB2182621.P#1

还要注意 > Properties > General

下的SQL版本<前>版本 10.50.2500.0

We tried moving a TFS Project Collection from one TFS 2010 server to another.

1. Detached the collection in TFS Console on source server
2. Backed up the collection, Tfs_DefaultCollection, in SQL Server 2008 Standard Edition
3. DBA restored the Collection to a new database, Tfs_MyCollection, to the SQL Server 2008 Enterprise, R2, instance used by the target TFS Server.
4. TFS Administrator attempted to attach to the target server.

TFS adminisitrator received the following error message.

TF254078: No attachable databases were found on the following instance of SQL Server: MyServerName. Verify that both the name of the server and the name of the instance are correct and that the database was properly detached using the detach command in the Team Foundation Administration Console.

I assmumed we did not need to prepare the database instance in the target server since it already contained a TFS Project Collection. I assumed that going up in a SQL Server edition was acceptable.

Are my assumptions valid? What could be the cause of not being able to attach to the new TFS Server?

btw, I created this post on ServerFault originally Mirror in Serverfault, but it generated very little interest there.

解决方案

Make sure both the TFS service level and SQL server versions match the previous server.
You can verify this information using SQL Management Studio > Databases > Tfs_Configuration or Tfs_DefaultCollection > Properties > Extended Properties

Note these properties:

TFS_PRODUCT_VERSION 10.0.40219.1
TFS_SCHEMA_VERSION  Microsoft Team Foundation Server 2010 (SP1)
TFS_SERVICE_LEVEL   Tfs2010.SP1.KB2182621.P#1

Also note the SQL version under <database instance name> > Properties > General

Version             10.50.2500.0

这篇关于为什么我不能将 TFS 附加到已正确还原到 SQL Server(我认为)的项目集合?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！