How to recover .net source code files from the TFS backup file.

Question

How to recover .net source code files from the TFS backup file.

eSRC 0

I restored the TFS server using SSMS and trying to connect with the Azure DevOps server hoping to restore the source code of an existing project. But I while trying to attach the collection, the DevOps server is unable to recognize the collection database. I want to restore the .net source code from the tfs backup file.

Anurag Rohikar 3,190 Reputation points Microsoft External Staff Moderator

2025-09-04T12:16:16.5133333+00:00
Hello eSRC, Thanks for sharing the details. Before jumping into solutions, could you clarify a couple of things so we can point you in the right direction?

Which version of TFS/Azure DevOps Server did you take the backup from, and which version are you trying to restore to now?

Did you back up and restore all the necessary databases, including the Configuration Database? Restoring a project collection without its corresponding configuration database will fail. The Configuration DB contains critical information about the server and all of its collections.

Is your goal to fully restore the TFS environment or do you just need to recover the .NET source code files?
These details matter because TFS databases can’t just be restored in SQL Server and connected directly the server expects them to be registered through the application tier.

Once you share the version details and whether you need a full restore or just the source code, we can guide you with the exact next steps. Thank you!
Anurag Rohikar 3,190 Reputation points Microsoft External Staff Moderator

2025-09-05T08:08:43.64+00:00

Hello eSRC, following up to see if you have a chance to check my previous response and help us with requested information to check and assist you further on this. Thank you!
Anurag Rohikar 3,190 Reputation points Microsoft External Staff Moderator

2025-09-08T08:06:37.3733333+00:00

Hello eSRC, just checking to see if you have a chance to check my previous response and help us with requested information to check and assist you further on this. Thank you!

1 answer

Your answer

Anurag Rohikar 3,190 Reputation points Microsoft External Staff Moderator

2025-09-04T12:16:16.5133333+00:00

Hello eSRC, Thanks for sharing the details. Before jumping into solutions, could you clarify a couple of things so we can point you in the right direction?

Which version of TFS/Azure DevOps Server did you take the backup from, and which version are you trying to restore to now?

Did you back up and restore all the necessary databases, including the Configuration Database? Restoring a project collection without its corresponding configuration database will fail. The Configuration DB contains critical information about the server and all of its collections.

Is your goal to fully restore the TFS environment or do you just need to recover the .NET source code files?
These details matter because TFS databases can’t just be restored in SQL Server and connected directly the server expects them to be registered through the application tier.

Once you share the version details and whether you need a full restore or just the source code, we can guide you with the exact next steps. Thank you!
Anurag Rohikar 3,190 Reputation points Microsoft External Staff Moderator

2025-09-05T08:08:43.64+00:00

Hello eSRC, following up to see if you have a chance to check my previous response and help us with requested information to check and assist you further on this. Thank you!
Anurag Rohikar 3,190 Reputation points Microsoft External Staff Moderator

2025-09-08T08:06:37.3733333+00:00

Hello eSRC, just checking to see if you have a chance to check my previous response and help us with requested information to check and assist you further on this. Thank you!

Answer 1

Hello,
When restoring a TFS/Azure DevOps Server project collection, simply restoring the database in SQL Server Management Studio (SSMS) is not enough. The TFS/DevOps application tier expects the database to be registered and attached in a very specific way. That’s why your DevOps server cannot recognize the collection database.

To recover your .NET source code, here are the supported options:

Use the TFS Admin Console to Attach the Collection

Open TFS Administration Console on your Azure DevOps/TFS server.

Navigate to Team Project Collections → Attach Collection.

Point it to your restored database.

This process runs validation, upgrades schema if needed, and formally registers the collection.

If the DB version is older/newer than your server version, you’ll need to install the matching TFS/Azure DevOps Server version before attaching.

If You Only Need Source Code (Not Full TFS)

If your main goal is just to recover the .NET source files and not the full TFS environment:

Restore the collection DB in SSMS.

You can query the tbl_VersionControl tables in the database (not officially supported, but technically possible) to extract file contents.

However, this is painful and unsupported.

Instead, use the official TFS Integration Platform or install a matching version of Azure DevOps Server (on-prem), attach the collection properly, and then use Team Explorer/Visual Studio to get the latest source code.

Important Notes

You must restore all related databases (Configuration DB + Collection DB + optionally Warehouse/Analysis if you need reporting).

TFS collection DBs are not standalone – attaching only one DB will fail.

Versions must match: if your backup is from TFS 2017, you need TFS 2017 to restore and then upgrade step by step.

Additional Reference:

I hope the above information helps, to exactly troubleshoot further please help us with requested information to check and assist you further on this. Thank you!

Share via

How to recover .net source code files from the TFS backup file.

1 answer

Your answer