TFS Corrupted Database Project Odyssee

• I am updating another version of Visual Studio 2013 (Update 3) on a different machine with a machine.

• Then I tried to create a test project in an existing collection. it broke. Tried this three times and then deleted the corrupted projects.

• After that, I decided. Well, I have to upgrade to TFS 2013 (update 3) too. So he tried to update my existing collections. This failed for a collection with a damaged project.

• So, I just simplified the database recovery. But it’s not that easy. And it tells me that I need to restore the db config as well. For this I need to rename the db config. But then I can't start the recovery management tool ?! He freezes.

• What would you suggest? I have a backup, but I cannot restore it yet. And I don't understand why he is telling me that I also need to restore a configuration backup. I always emphasize that collections are independent.

Here are some screenshots:

Ask an update problem: Full screenshot:

[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.

      

        
        
        
      

    

As I said, I ran a best practice analyzer.

The update log is actually large. I only post the last lines:

"[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 
"

      

        
        
        
      

    

When I try to execute it, this happens:

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.

      

        
        
        
      

    

When I try to restore a backup, this happens:

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