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!