- Nothing can beat experience

Upgrade TFS 2010 to TFS 2012 with Migration to a New Hardware - Part 5: Restore DBs and Reporting Encryption Key

In this blog series, I start to explain a step-by-step tutorial on how to upgrade an existing TFS 2010 to TFS 2012 Update 1 with the migration to new hardware. The series will include videos and images as well. In the last post, I will include one video that collects all parts for a one-shot view. This series consists of the following parts:

Each part consists of one or many sections as needed.

Part 5 - Restore DBs and Reporting Encryption Key

  • Run TFS 2012 Restore Tool and restore old DBs to the new SQL Server 2012.
  • Change Reporting DB and restore Reporting Encryption Key.

The following is the video that explains this blog post.

Run TFS 2012 Restore Tool and restore old DBs to the new SQL Server 2012

In this section, I will explain how to restore the backup DBs to the new SQL Server 2012 using the new tools TFSRestore.exe.

Get back to the command line on the new machine (TFS 2012), type TFSRestore and then enter.


The TFS restore tool will launch.


Click Connect and in the Select Backup Location, add the shared folder that has been created earlier and now has all backup files, select all DBs, and check Overwrite the existing database(s) to replace the existing Reporting Service DB, otherwise the restore will fail.


Review the success of the restore.


Change Reporting DB and restore Reporting Encryption Key

Open the Reporting Service Configuration Manager.


Click Connect to the new server (TFS12UP), then click on the Database tab and then click on Change Database.


Select Choose an existing report server database and then click Next.

51-Choose an existing report

Test the connection to the server and then click Next.

52-test connection

Select the Report Server database from the drop-down and then click Next.


In Authentication Type, leave the default (Service Credential) and then click Next.


In Summary, review and click Next.


Review the success of changing the DB.


Click on the Encryption Keys tab and then click on the Restore button, select the shared folder path that has the backup key, type the password that we used during the key backup, and click OK.


Review the success of restoring the key.


Click on Scale-out Deployment, select the old TFS machine (TFS2010) and click on Remove Server. If you have the same error as me, you will need to remove that manually.


Go to the SQL Server RSKeyMgmt Tool folder and copy the path “C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn”.


Open the command line tool as Administrator, type cd and paste the path of the tool.


Type RSKeyMgmt -l to list all servers with their GUIDs.


Copy the GUID of the old server (TFS2010), type RSKeyMgmt -r and paste the GUID to remove this server, then list again to make sure that the server was successfully removed.


Review the Scale-out Deployment to make sure it’s removed.


Trending Tags