Walkthrough: Backing Up and Restoring a Team Foundation Server

Performing backups is an important component of managing your Team Foundation deployment. Implementing a well-planned backup and restore strategy protects your data against data loss due to damage caused by a variety of failures. Testing your strategy by restoring a set of backups and recovering your database prepares you to respond effectively to a disaster.

Required Permissions

You must be a member of the Administrators group on the Team Foundation data-tier server, a member of the Team Foundation Administrators group, and either a member of the SQL Server Administrator group on the Team Foundation data-tier server or have the SQL Server Perform Back Up and Create Maintenance Plan permissions set to Allow to complete this procedure. For more information about permissions, see Team Foundation Server Permissions.

To backup and restore a Team Foundation Server deployment

  1. Read the following topics, Planning for Backup and Restore and Backing Up the Team Foundation Server.

  2. To learn about how to create a maintenance plan that backs up all Team Foundation databases and back up the Report Server encryption key, see How to: Back Up a Team Foundation Server.

  3. To learn about how to restore the Team Foundation databases and import the Report Server encryption key, see How to: Restore Team Foundation Server Data.

  4. When restoring the Team Foundation databases to a data-tier server with a different name, you must also update the application-tier server with the new data-tier name. For more information, see How to: Restore Team Foundation Server Data to a Different Server.

See Also

Tasks

How to: Back Up a Team Foundation Server
How to: Restore Team Foundation Server Data to a Different Server

Concepts

Planning for Backup and Restore
Backing Up the Team Foundation Server
How to: Restore Team Foundation Server Data

Other Resources

Backing Up and Restoring Team Foundation Server Data
Backing Up and Restoring Databases in SQL Server