TFS 2010 Cannot Create Backup Plan
I have recently moved our TFS 2010 server to new server, I was trying to create a backup plan but TFS tells me that A backup plan already exists for this Tfs configuration.
EXEC sp_dropextendedproperty @name = 'TFS_BACKUP_PLAN_CONTROLLER'
The power tool 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'
Comments