'TFS DB backup using SQL Server 2008?

TFS have more then one DB.. I want to take backup every day...

No need to over rite every day back up it want to create separate

Help me



Solution 1:[1]

Open SQL Server Management Studio, connect to your TFS, open Management, right-click Maintenance Plans, select New Maintenance Plan, follow the wizard.

Solution 2:[2]

In the TFS 2010 September Power Tools there is a backup plan wizard to backup your TFS server (read tfs databases) on a regular base: Link

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Stu
Solution 2 Glorfindel