TFS Backup Plan Wizard - A backup plan already exists for the TFS Configuration

TFS 2010 server to another TFS 2010 server and trying to 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:

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

By using the restore wizard included with this tool, you can restore your entire deployment to new hardware, or selectively restore team project collections to an earlier point in time.

Problem

But when you migrate from One TFS server to another, you are run your self into the following error message – TF254027: Error – Backup Plan Verifications – A backup plan already exists for this Tfs Configuration.

Solution

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 by,

Use Tfs_Configuration   EXEC sp_dropextendedproperty @name = 'TFS_BACKUP_PLAN_CONTROLLER'

​