locked
TFS 2012/2013 How restore attached TFS-collection to a different server? RRS feed

  • Question

  • Hi gues!

    How restore attached TFS-collection to a different TFS-server with different instance name?

    SQL server remains the same.

    ps: TFS 2013


    • Edited by Delmar74 Thursday, December 26, 2013 6:57 AM
    Thursday, December 26, 2013 6:54 AM

Answers

  • Hi Delmar,

    Thanks for your post.

    If you have already configured the new TFS 2013 Server on another hardware, and you want only move the collections from current TFS 2012/TFS 2013 to the new TFS 2013 Server, you can try the following steps(your current TFS 2012/TFS 2013 Server still working): 

    1        On current TFS 2012/TFS 2013 Server, launch TFS Admin Console>>under Team Project Collections tab, Detach the collection. Detach process is essential and should happen successful.

    2        Backup the Detached database(the collection database on your current TFS 2012/TFS 2013 Server).

    3        Restore the database to the new TFS 2013 Server’s SQL instance.(After restored successfully, ensure the collection database displayed in new TFS 2013 Server’s SQL instance correctly)

    4        On new TFS 2013 Server, launch the TFS Admin Console>>under Team Project Collections tab, Attach the collection. 

    To move collection with Reports and sites, please refer to the detailed steps in this document: http://msdn.microsoft.com/en-us/library/dd936138(v=vs.110).aspx.


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Thursday, December 26, 2013 9:54 AM
    Moderator
  • Hi Delmar74,

    Thanks for your reply.

    In TFS 2010, we can use the TFSConfig Recover command, you can refer to ArunRama’s answer reply in this post: http://social.msdn.microsoft.com/Forums/en-US/1497dc50-1cf8-4bfb-af11-e3a9f7e3b936/move-tfs-2010-to-a-totally-different-server?forum=tfssetup.

    But this TFSConfig Recover command has been deprecated after TFS 2010. If you need to recover your deployment after a disaster, please refer to the information this document: http://msdn.microsoft.com/en-us/library/ff407077.aspx.


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Friday, December 27, 2013 11:20 AM
    Moderator

All replies

  • Hi Delmar,

    Thanks for your post.

    If you have already configured the new TFS 2013 Server on another hardware, and you want only move the collections from current TFS 2012/TFS 2013 to the new TFS 2013 Server, you can try the following steps(your current TFS 2012/TFS 2013 Server still working): 

    1        On current TFS 2012/TFS 2013 Server, launch TFS Admin Console>>under Team Project Collections tab, Detach the collection. Detach process is essential and should happen successful.

    2        Backup the Detached database(the collection database on your current TFS 2012/TFS 2013 Server).

    3        Restore the database to the new TFS 2013 Server’s SQL instance.(After restored successfully, ensure the collection database displayed in new TFS 2013 Server’s SQL instance correctly)

    4        On new TFS 2013 Server, launch the TFS Admin Console>>under Team Project Collections tab, Attach the collection. 

    To move collection with Reports and sites, please refer to the detailed steps in this document: http://msdn.microsoft.com/en-us/library/dd936138(v=vs.110).aspx.


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Thursday, December 26, 2013 9:54 AM
    Moderator
  • Thank you, but I have another case.

    I consider tfs app server failover scenario:

    I have backuped attached tfs collections (databases). I cant afford to detach for each backup. If app server will crash I should recover the backups (attached collections) to new app server. I want to test this failover scenario.  

    Any advises or ideas?

    Friday, December 27, 2013 10:23 AM
  • Hi Delmar74,

    Thanks for your reply.

    In TFS 2010, we can use the TFSConfig Recover command, you can refer to ArunRama’s answer reply in this post: http://social.msdn.microsoft.com/Forums/en-US/1497dc50-1cf8-4bfb-af11-e3a9f7e3b936/move-tfs-2010-to-a-totally-different-server?forum=tfssetup.

    But this TFSConfig Recover command has been deprecated after TFS 2010. If you need to recover your deployment after a disaster, please refer to the information this document: http://msdn.microsoft.com/en-us/library/ff407077.aspx.


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Friday, December 27, 2013 11:20 AM
    Moderator
  • Hi.

    We use DPM to create backups (TFS Databases). We would like to continue using DPM for the backups. 

    Can we use backups DPM (full backup databases) to restore using TFS Scheduled Backups tool making the necessary changes to the file BackupSets.xml?

    <?xml version="1.0"?>
    <BackupSets xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
      <Version>1</Version>
      <BackupSets>
        <TfsBackupSet Id="9858625933918570796" Time="15.01.2014 17:35:06">
          <BackupSetType>Full</BackupSetType>
          <Result>Success</Result>
          <Databases>
            <BackupSetDatabase Name="Tfs_Configuration" File="Tfs_Configuration_9858625933918570796F.bak" />
            <BackupSetDatabase Name="Tfs_Collection" File="Tfs_Collection_9858625933918570796F.bak" />
          </Databases>
        </TfsBackupSet>
        <TfsBackupSet Id="9858626144665204645" Time="15.01.2014 23:26:21">
          <BackupSetType>Transactional</BackupSetType>
          <Result>Success</Result>
          <Databases>
            <BackupSetDatabase Name="Tfs_Collection" File="Tfs_Collection_9858626144665204645L.trn" ParentId="9858625933918570796" />
            <BackupSetDatabase Name="Tfs_Configuration" File="Tfs_Configuration_9858626144665204645L.trn" ParentId="9858625933918570796" />
          </Databases>
        </TfsBackupSet>
      </BackupSets>
    </BackupSets>

    Thursday, January 16, 2014 2:57 PM
  • Hi Delmar, 

    Thanks for your reply.

    If you created backup files using DPM, I think you should perform the restore using SQL Server Management Studio manually.

     


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    • Proposed as answer by B B B B Thursday, August 18, 2016 5:29 PM
    Friday, January 17, 2014 1:45 AM
    Moderator
  • (In cooperation with Delmar)

    1. TFS Database is in attached state

    2. Resore should be performed at another TFS Server.

    So your advice is not applicable to the case, because Tfs Configuration database has not recovered TFS instance.

    Friday, January 17, 2014 5:48 AM
  • Hi,

    After you restored collection database on a different SQL Server, you can use TfsConfig remapdbs command to configure TFS to use this database. See my post from December 9 on the following thread: http://social.msdn.microsoft.com/Forums/en-US/7e89cb11-823d-4698-a1b2-b626d89ee60a/switch-sql-server-instance?forum=tfsadmin for instructions.

    Thanks,
    --Vladimir

    Saturday, January 18, 2014 5:51 PM
    Moderator
  • In my case, change the server name TFS (not SQL instance).

    Alternative text: в моём случае изменяется только имя TFS сервера (а не SQL). Необходимо восстановить TFS-сервер на новом сервере (с другим именем), при этом SQL-сервер может остаться тот же, который был.

    Sunday, January 19, 2014 12:35 PM
  • Hi,

    you can do the following:

    1) Install TFS on your new server (the same version as your current one).

    2) When Team Foundation Server Configuration Center dialog pops up, select "Application Tier Only" Wizard to configure the server.

    3) After server is configured, you will need to update Team Foundation Server URLs, update your build servers and send mail to your TFS users, where you would tell them new server address. See the following for details:
    http://msdn.microsoft.com/en-us/library/ms404869.aspx#InstallAndConfigure

    Thanks,

    --Vladimir

    Sunday, January 19, 2014 5:58 PM
    Moderator