prerequistes: make sure both machines have the same version of tfs and have the same patches. Example: We had our old version with sp1 and the new tfs only had RTM. You will need to apply sp1 so no version conflicts occur with tfs_configuration.
Don’t worry about migrating the tfs_warehouse and analysis cubes as those can be rebuilt from tfs_configuration.
So work on reporting after you have tfs_configuration working on the new box.
- stop collection
- backup databases
- using sql server job
restore databases - using dbchangemanagement
run sequence of commands as administrator
cd C:\program files\Microsoft Team Foundation Server 2010\Tools TFSServiceControl quiesce TFSConfig PrepSQL /SQLInstance:TFS TFSConfig RemapDBs /DatabaseName:TFS;TFS\_Configuration /SQLInstances:TFS /continue TFSConfig RemapDBs /DatabaseName:TFS;TFS\_Configuration /SQLInstances:TFS /continue TfsConfig registerDB /SQLInstance:TFS /DatabaseName:Tfs\_Configuration TFSServiceControl unquiesce