Team Foundation Server Backup Plan Wizard – A backup plan already exists for the TFS_Configuration

You configure a backup plan using the Backup plan wizard that comes along with the TFS Power Tools. The tool allows you to set up Team Foundation Server backups.

The tool can schedule backups for the following databases that your deployment of Team Foundation Server uses:

1. the configuration database
2. the database for each team project collection
3. the databases that Team Foundation Server uses in conjunction with SharePoint Products, if your deployment includes integration with SharePoint Products
4. the databases that Team Foundation Server uses in conjunction with SQL Server Reporting Services, if your deployment includes reports

The wizard has a feature to prevent multiple backup plans from being created for the same TFS databases (because they might interfere). It works by setting an extended attribute in the TFS Configuration SQL database (called TFS_BACKUP_PLAN_CONTROLLER) that identifies a configured backup plan. You can’t configure another backup plan from a different machine. To do it, you will need to delete this extended attribute using SQL Server Management Studio.

You can use the following command to delete the attribute:

USE Tfs_Configuration
EXEC sp_dropextendedproperty @name = ‘TFS_BACKUP_PLAN_CONTROLLER’

Advertisements

Performing a “Do Over” of Team Foundation Server 2010 Configuration

If you need to perform the configuration again, then you can use the steps described below assuming that you have only configured ONE (1) team project collection called DefaultCollection:

Step 1. Use the Team Foundation Server Configuration Tool to unconfigure components on the server:

cd “%ProgramFiles%\Microsoft Team Foundation Server 2010\Tools”

TfsConfig.exe setup /uninstall:All

Step 2. Delete all the Team Foundation Server 2010 related databases through the SQL Server Management Studio:

Tfs_Configuration
Tfs_DefaultCollection (if you have more than ONE (1) team project collections, then you need to remove all the team project collection databases.)
Tfs_Warehouse
Tfs_Analysis (Analysis Services)

Step 3. Delete all the Team Foundation Server 2010 related data sources through the Report Manager:

Tfs2010OlapReportDS
Tfs2010ReportDS

Step 4. Delete the Team Foundation Server 2010 related folder through the Report Manager:

TfsReports