Moving TFS servers

Folks,

There have been a number of postings requesting instructions on how to move servers (covering some of the following scenarios):

  • Moving TFS from a workgroup to a domain
  • Moving TFS from a Test domain to a Production domain
  • Moving TFS (single server) from one machine to another (disaster recovery for single server)
  • Moving TFS from single server configuration to dual server configuration.

These instructions are not currently available as part of the latest MSDN documentation, but I'm happy to announce that they are avaialable here: http://blogs.msdn.com/vstsue/archive/2006/03/22/558178.aspx. As the blog article says, this information should find it’s way to the latest MSDN docs in roughly 6 weeks time.

Although we have tested various move scenarios, our testing environment is likely to be very different from your environments, so we’d be especially interested to hear of any issues that you run into when trying to move servers, using these new instructions.

Thanks,




Answer this question

Moving TFS servers

  • Alcedes78

    Some more information...

    Event Viewer reports that TFSWorkItemTracking job failed because it did not have access to the server. Viewing this job in Sql Management Studio shows that the job has nothing in the Owner field. If I specify <domain>\TFSSERVICE account here the job will run OK.

    It appears that all jobs has no owner information!!

    Whould this be because in the old domain the owner for the jobs and the databases would have been <olddomain>\administrator and that domain account does not exist in the new domain

    Thanks

    Graham


  • Simon Hogg

    I'm having this issue - was this issue ever solved

    I.e., the TFSAdminUtil ChangeAccount error


  • vishal singh

    As to point 1, are there any solutions to fix the situation where one follows the instructions and restores the STS_Config_TFS database when they shouldn't have. We followed those instructions and now don't know how to correct the situation. I have found this problem mentioned in many Blogs and forums but no solutions. Any help appreciated.

    Thanks,

    Ed


  • mike82y

    I am trying to do a dual server setup right now to a new set of servers. I am hitting a wall while trying to change the accounts.

    I am trying to run the two commands below:

    TfsAdminUtil ChangeAccount OldDomainOrOldComputerName\OldTFSServiceAccount NewDomainOrNewComputerName\NewTFSServiceAccount NewPassword

    TfsAdminUtil ChangeAccount OldDomainOrOldComputerName\OldTFSReportingServiceAccount NewDomainOrNewComputerName\NewTFSReportingServiceAccount NewPassword

    And i get this error:

    Status: Update database account on database server: ccitfsxxsat.
    ERROR: TF30040: The database is not correctly configured. Contact your Team Foun
    dation Server administrator.

    I keep looking at the DB permissions, i can't find anything wrong. Any help is appreciated


  • Satyendra Gupta

    Follwoing on from above, in the "How To: Move from a single-server to a dual-server deployment" there is a small error in the documentation:

    Under "To restore data from the original Team Foundation Server single-server deployment to the new Team Foundation Server data-tier server"...

    Point 2.1 states:

    On the new Team Foundation data-tier server, open a command prompt window and change directories to drive:\%programfiles%\Microsoft Visual Studio 2005 Team Foundation Server\Web Services\Services.

    This is wrong - it should be done on the application-tier, not the data-tier.

    Also, just commenting on the notes above - which are awesome - Point 1, is an absolute show stopper. I spent hours trying to work out why WSS was stuffed because I missed that one comment saying not to restore the Config database. This really needs to be made clear in the "Restore Team Foundation Server Data to a Different Server" document as it is really easy to miss in the other documents.


  • Seth Paul

    Hi,

    I am attempting to use the procedure regarding the restoration of a single server in the same domain to a different machine and am having considerable difficulties.

    First of all, I think there is a step missing in the "How to: Move Your Team Foundation Server from One Hardware Configuration to Another" procedure in the restoring Report Server section. When adding a new user in the _WarehouseConfig Permissions roles should be selected from the checkboxes to the user added or that user is not added correctly. Step #23.

    I have performed this procedure several times and haven't been able to successfully restore our server. I currently have a server restored with SharePoint and Reporting Services fully functional however I don't seem to have access to work items and source control.

    I can run the Work items report and see all the work items, however from within Team Explorer, I don't the queries are not listed under projects that were part of the databases restored.

    When I go to access source control for any of the restored projects I get the following error message:

    Configure Source Control

    Either source control has not been configured for this team project or you do not have permission to access it. would you like to create the source control folder, $/ProjectName

    On a side note, since performing the restore I have successfully been able to create a new project and the work items and source control seem to work correctly.

    Thanks in advance!

    ___________________________

    Sarah Cameron - InCycle Software


  • Donald Sechrest

    Update: the reason I wasn't able to move servers was because of a problem with permissions when moving a Beta 3 refresh server.

    Recently, I have successfully moved an TFS RTM server - single server configuration to another single server in the same domain following the above referenced procedures (Moving TFS (single server) from one machine to another) .

    ___________________________

    Sarah Cameron - InCycle Software


  • dncjp

    We just ran through the migration process using the two documents below:

    Migration of TFS content from one environment to another (restore based move)

    How to: Restore Team Foundation Server Data to a Different Server

    Pasted from <http://msdn2.microsoft.com/en-us/library/ms252516(VS.80).aspx>

    How to: Move Your Team Foundation Server from One Hardware Configuration to Another

    Pasted from <http://msdn2.microsoft.com/en-us/library/ms404869(VS.80).aspx>

    During the process we ran into a few "glitches" and I wanted to share them.

    1. Depending on which restore document you use (there's a restore section in each of the above docs) you are told to either restore or not restore the SharePoint Configuration Database for restore-based moves. Very confusing. Oh, you might want to specify the NAME of the "SharePoint Configuration Database" that you shoud / should not restore (STS_Config_TFS).
    2. TfsActivityLogging database is listed as "optional" with no info on why or why not to restore it. If its that optional, delete the sucker. I have plenty to do already.
    3. Under "To restore and verify Report Server on the new Team Foundation Server", step # 10 CANNOT be completed until step # 11.
    4. The SQL Report Server steps ("If you are running SQL Report Server Enterprise Edition" and "If you are running SQL Report Server Standard Edition") are confusing. Do you only complete steps 1-4 for Enterprise Edition And steps 1-29 for Standard Edition (I didn't think so).
    5. Under the same section, default browser security settings on Windows 2003 SP1 do not allow you to connect to http://localhost/reports - it requires you to add localhost to your trusted zone.
    6. Under the same section, step #20 misses the step of expanding the Tables section under TFSWarehouse
    7. Under " To restart services and verify operation" step # 4 should say "On the Team Foundation application tier server" not "data tier server".
    8. On that same step, no xml response is returned by the "invoke". That's confusing.


  • TheHood

    Dan,

    I have had real problems with some one of these procedures, I've posted comments on the blog above but I have had no response.

    The problem comes when moving a server from one domain to a another.

    I managed to move my RC teamserver to new hardware in the old domain, I then upgraded it to RTM in the old domain. I tested it and it all seemed to work ok

    Now when I try to move to a new domain following these instructions it appears to stop working.

    Having followed the instructions on moving TFS to a new environment (single server) when I go to view a report through http://localhost/reports I gets an error saying <domain>/<tfs report service account> do not have access to TFSWarehouse, or TFSWarehouse does not exist.

    Also, once moved to the new domain when I use Sql Management Studio to look at the properties of the TFSWarehouse database I get an error saying it cannot display the dialog. The full error is:

    TITLE: Microsoft SQL Server Management Studio
    ------------------------------

    Cannot show requested dialog.

    ------------------------------
    ADDITIONAL INFORMATION:

    Cannot show requested dialog. (SqlMgmt)

    ------------------------------

    Property Owner is not available for Database '[TFSWarehouse]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)

    For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=9.00.1523.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.PropertyCannotBeRetrievedExceptionText&EvtID=Owner&LinkId=20476

    ------------------------------
    BUTTONS:

    OK
    ------------------------------

    Can anyone help me

    Regards

    Graham


  • P J Walklate

    Hello Everyone,

    Searching with "upgrading, migrating, and moving" finally brought me to this thread. I would like to know the pro and con for migrating from TFS 2005 to TFS 2008.

    We have an existing dual tier system; I recently added WSS 3.0 functionality to the environment and my inclination is to backup the key elements and wipe out the application tier. Install a "fresh" copy of TFS 2008 and restore the data to the new environment. From what I'm reading there doesn't seem to be an option to do this and I'm probably being stubborn because of my previous experiences with upgrades.

    If TFS 2008 supports a flawless "upgrade in place" for my environment I would seriously consider it.

    Finally, if this isn't the best place to post this query I apologize.

    Thanks in advance for any help/suggestions you can provide.



  • Moving TFS servers