Database backup tools not available in Power Tools?

Question

I came across a situation where I need powershell scripts for tfs that need to be installed on the tfs server (we have everything for tfs on one server). Trying to change the installation did not allow me to install powershell scripts, so I decided to download the latest version of tfs 2012 power tools and perform uninstallation and installation. The problem is that when I install only the components that it allows me to install, it is the “Best Practice Analyzer” and the “Test Additive Cleaner”. This prevents me from installing the “Standby Database Tools” (this is an urgent need now) or the powershell scripts that I originally wanted to install.

Answer 1

To add to the answer Aghilas. If you take something in Visual Studio Gallary:
Microsoft Visual Studio Team Foundation Server 2012 Power Tools

he will not have backup tools. But if you download here
Microsoft Team Foundation Server Power Tools

He will have backup tools. What is even more confusing is that if you have tools (in the 2nd link installed) and you try to install client tools (in the first link), he will ask you if you want to change the installation. Since I installed the tools, but I thought that they used to host the backup tools, and just did not install them if you were not on the server. Maybe I'm wrong. I will try to install "Team Explorer" and see if this allows you to install powershell scripts (in the prerequisites for the first link).

Update 2: That was the key. I had to install Team Explorer, and then he let me install powershell scripts. It also seems that the tools in the 2nd link have everything, and the 1st link has everything minus the backup tools.

Answer 2

Backup Database Tools is not available on SQL Server Product in your Power Tools , it contains configuration tools, for example, Test Attachment Cleaner is used to attach cleau or free storage space

Answer 3

I believe that the TFS version is very important here. Most of these tools are for RTF version TFS 12. I had version 11.0, and it just didn't work with the interface.

The easiest element is to run it directly. C: \ Program Files \ Microsoft Team Foundation Server 11.0 \ Tools \ TFSBackup.exe. As soon as I ran this program, it worked, however, I clearly would like to create a graph, which, I suspect, can be done using powershell. Another problem that I encountered was to back up this network, which I could not do because the SQL instance was running under the local computer administrator account.

Answer 4

The db backup tools were part of the TFS 2012 power tools, but it seems they were removed after Update 1. Even from the MS Download Center , the last boot did not have db tools. They are in update version 1, which you can select above it:

So, if you need TFS db backup tools in the world of 2012, you need the correct version of the tools:

• TFS 2012 (which also means SQL 2012, since TFS 2012 will not recognize SQL 2014)
• Visual Studio Team Foundation Server 2012 Update 1 Power Tools with a focus on Update 1, and not on any later version than Update 1.

NOTE db backup / restore is standard on TFS 2013. These tools are for TFS 2012. After installing TFS 2013, I wanted to use db backup tools, but I found that they were not present in 2013 power tools. The reason is that the functionality is now included in the standard TFS and is accessible from the TFS administration console without installing power tools.