Creating a TFS database back up schedule
"If you fail to plan, you are planning to fail!" | ||
| --Benjamin Franklin | ||
No one wants to be the administrator of a server that goes down without a complete set of backups in place. TFS Database sits at the core of the product; the database is the repository of the data you interact with using Web Portal, Visual Studio, and Microsoft Test Manager. In this recipe, you'll learn about the database backup capability available with in TFS.
Getting ready
To configure the backup schedule, you will need to be a member of the TFS Administrator Group, a member of SQL Server Administrator Group, and (if your deployment uses SharePoint Products) a member of the Farm Administrators Group.
The TFS Service Account must have a SQL Server perform backup and create maintenance plan permissions set to allow on each instance of the SQL Server that hosts the databases that you want to back up. You need a network share to store the database backup. The service account needs full...
