visual-studio - TFS 损坏的数据库项目 Odyssee

Question

1. 我一直在另一台机器开发机器上升级到另一个 Visual Studio 2013 版(更新 3)。

2. 然后我尝试在现有集合中创建一个测试项目。它坠毁了。尝试了三遍，然后删除了损坏的项目。

3. 在那之后我坚持了下来。好吧，我也应该升级到 TFS 2013(更新 3)。所以它试图升级我现有的收藏。包含损坏项目的集合失败。

4. 所以我认为恢复数据库很简单。但这并不容易。它告诉我我也需要恢复配置数据库。为此，它说我需要重命名配置数据库。但是后来我无法启动管理工具来恢复？!它卡住了。

5. 您有什么建议？我有备份，但目前无法恢复。而且我不明白为什么它告诉我我也需要恢复配置备份。我一直认为收藏是独立的。

下面是一些额外的截图:

升级过程中的问题: 完整截图:

[2014-08-07 23:30:13Z][Error] TF400744: An error occurred while executing the following script: SetRecoveryModelToSimple.sql. Failed batch starts on the line 1. Statement line: 1. Script line: 1. Error: 5069 ALTER DATABASE statement failed.

按照建议，我已经运行了最佳实践分析器。

升级日志其实很大。我只发布最后几行:

"[Info   @23:29:51.189] 
[Info   @23:29:51.189] +-+-+-+-+-| ResultsSqmData |+-+-+-+-+-
[Info   @23:29:51.189] Feature: ApplicationTier (1)
[Info   @23:29:51.190] Feature: ApplicationTier; previousFailure: False
[Info   @23:29:51.192] Error count: 0
[Info   @23:29:51.192] Warning count: 0
[Info   @23:29:51.192] Overall Result: TotalSuccess (1)
[Info   @23:29:51.192] WebSiteData: 9
[Info   @23:29:51.192] SqlData: 8
[Info   @23:29:51.193] RSData: 0
[Info   @23:29:51.193] WSSData: 0
[Info   @23:29:51.193] Wizard: UpgradeWizard (4)
[Info   @23:29:51.193] TfsConfigData: 8194
[Info   @23:29:51.197] serviceLevel: Dev12.M68
[Info   @23:29:51.197] Fatal Error Location: 0
[Info   @23:29:51.197] Activity = ApplicationTierUpgrade (4)
[Info   @23:29:53.053] ResultSqmData.UpdateIssues
[Info   @23:29:53.068] no issues
[Error  @06:53:08.370] TF400744: An error occurred while executing the following script: SetRecoveryModelToSimple.sql. Failed batch starts on the line 1. Statement line: 1. Script line: 1. Error: 5069 ALTER DATABASE statement failed.
[Info   @06:53:08.385] To configure the new features for a team project, follow the steps in http://go.microsoft.com/fwlink/?LinkID=229859 
"

当我尝试分离它时，发生了这种情况:

TF401219: The team project collection 'XXX' cannot be detached because its version ID is different than the ID for the configuration database. The collection has the following version: Dev12.M62. The Team Foundation Server is at the following version: Dev12.M68.

当我尝试恢复备份时，发生了这种情况:

TF400990: Database Tfs_Configuration exists on SQL instance NUBO-XXX\SqlExpress. Please drop or rename the existing database before the restore operation

Answer 1

首先要保持冷静。

在尝试其他选项之前，我会尝试完成升级。从您显示的内容来看，您似乎在 SQL 级别有问题，可能是权限问题:检查 TFS 服务帐户和您的用户。

如果你想回滚，而且你使用了集成备份，实际上你必须恢复所有的数据库。