如何在TF备份计划中删除数据库
您好。
我已经安装了2011年3月的TFS2010 SP1。
I've installed tfpt Mar2011 with TFS2010 SP1.
在Team Foundation Backups中创建备份计划后，我删除了属于项目服务器的一些数据库。但即使我重新创建备份计划，数据库仍然在备份计划数据库中。备份任务无法成功完成，因此无法再找到这些
数据库。
After I create a backup plan in Team Foundation Backups, I removed some databases belongs to project server. But the databases are still in Backup Plan Databases, even after I recreate the backup plan. The backup task cannot finish successfully coz of these databases cannot be found any more.
如何解决此问题？
或者，如何完全删除备份计划？
Or, how to delete backup plan completely?
谢谢。
您收到此错误消息了吗？ TF254027：错误–备份计划验证–此Tfs配置已存在备份计划。
该向导具有防止为同一TFS数据库创建多个备份计划的功能（因为它们可能会干扰）。它的工作原理是在TFS配置SQL数据库（称为TFS_BACKUP_PLAN_CONTROLLER）中设置扩展属性，
标识已配置的备份计划。您无法从其他计算机配置其他备份计划。为此，您需要使用SQL Server Management Studio删除此扩展属性。查看此博客文章了解更多详情
http://geekswithblogs.net/TarunArora/archive/2011/07/13/tfs-backup-plan-wizard---a-backup-plan-已存在.aspx
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. Check this blog post for more details http://geekswithblogs.net/TarunArora/archive/2011/07/13/tfs-backup-plan-wizard---a-backup-plan-already-exists.aspx
您可以使用以下命令删除属性，
You can use the following command to delete the attribute by,
Use Tfs_Configuration
EXEC sp_dropextendedproperty @name = 'TFS_BACKUP_PLAN_CONTROLLER'或者，
转到"tbl_JobQueue" "Tfs_Configuration"中的表格数据库并清除条目，然后您应该能够继续。
http ：//*.com/questions/6663061/cannot-stop-tfs-2010-reporting-jobs/6663138#comment-7879515
Go to "tbl_JobQueue" table in "Tfs_Configuration" database and clear the entry, and then you should be able to proceed. http://*.com/questions/6663061/cannot-stop-tfs-2010-reporting-jobs/6663138#comment-7879515
HTH
干杯，塔伦