Backing up Team Foundation Server databases 101

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:


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


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


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


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.


Hope this helps!