TFS 2017：附加未分离的Collection DB [英] TFS 2017: Attach Collection DB which was not detached

问题描述

您好，

是否可以附加未正确数据的收集数据库？我们希望将Collection从一个TFS实例移动到另一个TFS实例。我们在Host1上分离它并试图将它附加到Host2但是附加过程由于某种原因失败了。
我们将数据库恢复到Collection应该已经分离的时间，但现在我们无法将它附加到任何地方。它甚至都不可见。

is it possible to attach a Collection Database which has not been datached properly? We wanted to move a Collection from one TFS Instance to an other. We detached it at Host1 and tried to attach it to Host2 but the attach process failed for some reason. We restored the Database to a time were the Collection should have been detached but now we cannot attach it anywhere. It is not even visible.

感谢所有答案。

推荐答案

分离的集合数据库应该将TFS_SNAPSHOT_STATE扩展属性设置为Complete。如果此属性不存在，则不会分离集合，也无法附加。您是否在
的同时作为收集数据库的备份获取了Tfs_Configuration数据库的备份？

如果您没有备份配置数据库那么您将无法附加集合 - 这是一个数据丢失案例。很抱歉这样说。



如果您有备份，那么如果您使用的是TFS 2015 Update 3或更高版本，则可以使用
tfsconfig OfflineDetach 命令，用于创建集合数据库"附连" ;.如果您使用的是旧版本的TFS，则可以在测试SQL Server实例上恢复配置和集合数据库的备份，针对这些数据库配置TFS
（您可以从配置数据库中的tbl_ServiceHost和tbl_Database表中删除其他集合） ）然后分离收集。之后，您将能够将该集合附加到另一个TFS实例。

Hi,
detached collection database should have TFS_SNAPSHOT_STATE extended attribute set to Complete. If this attribute does not exist then collection is not detached and it cannot be attached. Do you have backup of Tfs_Configuration database that was taken at the same time as backup of you collection database?
If you do not have have backup of the configuration database then you will not be able attach collection - this is a data loss case. Sorry to say this.

If you have backup, then if you are using TFS 2015 Update 3 or above you can use tfsconfig OfflineDetach command to make collection database "attachable". If you are using older version of TFS, you can restore backups of configuration and collection databases on a test SQL Server instance, configure TFS against those databases (you can delete other collections from the tbl_ServiceHost and tbl_Database tables in the configuration database) and then detach collection. After that, you will be able to attach that collection to another TFS instance.

谢谢，

- Vladimir

--Vladimir

这篇关于TFS 2017：附加未分离的Collection DB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！