Geeks With Blogs

News




View Tarun Arora's profile on LinkedIn

profile for Tarun Arora at Stack Overflow, Q&A for professional and enthusiast programmers

Tarun Arora - Visual Studio ALM MVP ALM, Agile, Automation, Performance Testing, Software QA, Cloud, ...

 

Recently moved from 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.

Backup Plan error

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'
Digg This
Posted on Wednesday, July 13, 2011 9:47 PM TFS2010 , Power Tools | Back to top


Comments on this post: TFS Backup Plan Wizard - A backup plan already exists for the TFS Configuration

# re: TFS Backup Plan Wizard - A backup plan already exists for the TFS Configuration
Requesting Gravatar...
Great tip ! thanks :D
Left by El Bruno on Jul 14, 2011 8:05 AM

# TFS 2010 power tool Error - cannot find reporting databases
Requesting Gravatar...
Error on creating the backup plan on Power tool:
Error [ Database inspection Verifications ] Cannot find reporting databases

this is single server configuration.
Left by Lourdes Satheesh on Oct 04, 2011 3:06 PM

# re: TFS Backup Plan Wizard - A backup plan already exists for the TFS Configuration
Requesting Gravatar...
u saved the day..
Left by forge geek on Dec 05, 2011 2:04 PM

# re: TFS Backup Plan Wizard - A backup plan already exists for the TFS Configuration
Requesting Gravatar...
Hi Forge Geek,

That is always a delight to know.

Cheers, Tarun
Left by Tarun Arora on Dec 05, 2011 2:10 PM

# re: TFS Backup Plan Wizard - A backup plan already exists for the TFS Configuration
Requesting Gravatar...
Thank you! Thank you!! Thank you!!!
for providing a concise & pin-pointed solution to this problem. Bless you.
Left by Tommy B on May 14, 2012 6:29 PM

# re: TFS Backup Plan Wizard - A backup plan already exists for the TFS Configuration
Requesting Gravatar...
ARIGATOU!!! From Japan.
Left by SHIMA on Aug 29, 2012 9:11 AM

# re: TFS Backup Plan Wizard - A backup plan already exists for the TFS Configuration
Requesting Gravatar...
@Shima - douitashimashite / your most welcome :-)

Cheers. Tarun
Left by Tarun Arora on Aug 29, 2012 12:18 PM

comments powered by Disqus

Copyright © Tarun Arora [Microsoft MVP] | Powered by: GeeksWithBlogs.net