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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: