I spent a little while poking through SQL Server Management Studio to figure out to backup my Team Foundation Server so I thought I would share it.

First, I fired up SQL Server Management Studio and started the Maintenance Plan Wizard:

Sql2

This wizard gives you a number of maintenance options, for now, I’m just interested in backing up my TFS databases.

Sql3

The next thing to do is to pick out the TFS databases - the ones that are created by TFS are listed below:

Frame90

Finally, there is the option to pick how often this plan runs – I chose to back my TFS up daily.

Frame108

Maintenance plans have a pretty rich workflow – so far I just have a basic backup setup, I’ll let you know if I add anything else.

Frame128

Hope this helps!

Eric.