tfs 2010 restore

Last updated on 2012-07-02 18:20 UTC

back to stuff

A brief procedure on how to restore a TFS 2010 backup on a new machine with only the necessary stuff

1. install SQL Server 2008 R2
2. install TFS using the advanced wizard
   • exclude reporting, analysis, sharepoint
   • set up the desired service user for TFS

1. do not start any GUI
2. open a command prompt — that is cmd.exe
3. stop the TFS service with TFSServiceControl quiesce
4. launch TFSConfig PrepSQL /SQLInstance: ServerName, replacing ServerName with the name of the SQL Server instance you installed on the first step
5. launch TFSConfig RemapDBS /DatabaseName:servername;TFS_Configuration /SQLInstances:servername /Continue
6. if it doesn’t work launch again
7. launch TFSConfig Accounts /ResetOwner /SQLInstance: ServerName /DatabaseName: DatabaseName
8. launch TFSConfig Accounts /add /AccountType:ApplicationTier /account: AccountName /SQLInstance: ServerName /DatabaseName: DatabaseName
9. launch TFSConfig registerDB /SQLInstance: ServerName /DatabaseName: DatabaseName
10. launch tfsservicecontrol unquiesce
11. client machine do not need any further reconfiguration, even if the server name changed, since they pick up the TFS server based on GUID

back to stuff