Easy backup of TFS 2012 Express Edition possible?

Question

I use the TFS 2012 Express edition for personal use (I use mostly it to versionize my sources).

I had a brief look in the documentation concerning backup strategies and it seem to be a hell of work :(. Are there any shortcuts available when I am just interested that my versionized sources can be backuped and restored?

Answer 1

If it's just backing up TFS occasionally, then I'd just download and install Microsoft® SQL Server® 2008 Management Studio Express.

In SQL Server Management Studio (SSMS) ...

1. Connect to ".\SQLEXPRESS"
2. Open the "Databases" node in the tree view on the left
3. Right click on each database having a "TFS" part in its name and select the context menu item "Tasks > Back Up..."

To restore TFS later (e.g. on a fresh Windows installation), again in SSMS ...

1. Connect to ".\SQLEXPRESS"
2. Open the "Databases" node in the tree view on the left
3. Right click on each database having a "TFS" part in its name and select the context menu item "Tasks > Restore > Database..."

Answer 2

Use this link: Microsoft Team Foundation Server Power Tools for installing the Power Tools including the Backup Assistent

For any reason, the Power-Tools from the Visual Studio Gallery, does not include the Backup Tools. See more in this SO Answer.

Answer 3

Backups made easy with the TFS Power Tools 2012 "Team Foundation Backup" feature.

It essentially creates a seamless process for backup/restore of the TFS databases.

Answer 4

Information provided in answer is based on TFS Standard Edition and not TFS 2012 Express. I have looked all over the internet and found just scripts that does it manually. I have installed the Power Tools Update 1 (Visual Studio Team Foundation Server 2012 Update 1 Power Tools.msi) and nothing has changed in the Console whatsoever.

Here is the alternative manual way :: Backing up TFS 2012 Express