Moving TFS 2010 Collections during Upgrade to RTM

(Note: Please download the latest Installation Guide for Team Foundation and read the Upgrade sections for details on types of upgrades and steps to perform an upgrade to TFS 2010)

TFS 2010 provides a lot of flexibility in how you manage your collections.  You can have multiple collections and easily move them from one SQL instance to another.  One common scenario is to load balance your system by spreading your collections across multiple data tiers.  You can do this before, during, or after upgrade to RTM.  If you move a collection as part of your upgrade, you must run the RemapDBs command before the upgrade.  The steps to follow are:

1. Backup DBs.

2. Uninstall TFS Beta 2 / Install TFS RTM

3. Move your collection database (backup/restore from SQL) to the new data tier

4. On TFS Application tier, run 'tfsconfig.exe remapdbs' and specify all your data tiers.  For example: 

tfsconfig remapdbs /sqlinstances:server1,server2\instancename /databasename:datatier1;Tfs_Configuration /analysisinstance:server3

5. Run the TFS Upgrade Wizard.

Note that if you move all your TFS databases to a new single data tier, you don't need to run RemapDBs.  TFS is smart enough to figure it out.  If you move one or a few database, you must run it.  Just to be safe I recommend you run RemapDBs anytime you move a TFS database.  There's no harm in running it.

Comments

• Anonymous
  June 30, 2010
  Hi, I'm not sure I understand your explainations... However it might be the answer to my problem. I had a server crash and all I'm left with is the backup of my project collection db. I've reinstalled everything but I'm unable to attach the restored db to a new collection since it was not dettached (of course , since the server crashed...)  and the db contains loads of data specific to the old server. Is remapdbs the solution ? cheers

• Anonymous
  August 17, 2010
  No RemapDBs won't work for that.  I think the Recover command is what you need: msdn.microsoft.com/.../ff407077.aspx