How to estimate the size of your Tfs database backup files

The most likely way to do this in my experience is to take a look at the most recent backup job. This can be done quite easily from a T-SQL script. Feel free to refine the bellow to suite your needs, but it should get you the basic information you require. SELECT TOP 100 s.database_name…

0

Tfs 2010… What version do I have and what version do I need?

Having the latest build of any Microsoft application is always recommended.  For TFS 2010 RTM, this is no different.  Please refer to the table bellow for your current version and links to getting the bits     TFS 2010 Build # Release Date Size Link TFS 2010 RTM 10.0.30319.1 Aug-05-2010 700.0 MB  http://www.microsoft.com/en-us/download/details.aspx?id=15070  TFS 2010…

1

What version of SQL am I currently running?

Here is a quick and simple SQL script to get the current SQL version installed. /*==============================================*/ — Retrieve version of MS SQL Server Select SERVERPROPERTY(‘productversion’) [Product Version], SERVERPROPERTY (‘productlevel’) [Product Level], SERVERPROPERTY (‘edition’) [Edition] /*==============================================*/   I personally use this awesome blog (http://sqlserverbuilds.blogspot.com) to then figure out if I am on the latest build etc.. Hope this…

1

TFS Client Tools

Here are some tools I find very handy in my day to day use of TFS.  Title URL Description Microsoft Visual Studio Team Foundation Server 2012 Power Tools http://visualstudiogallery.msdn.microsoft.com/b1ef7eb2-e084-4cb8-9bc7-06c3bad9148f Power Tools are a set of enhancements, tools, and command-line utilities that increase productivity of Team Foundation Server scenarios. Team Foundation Server Administration Too http://tfsadmin.codeplex.com The…

0

How can I restore all my Tfs Databases from script

In this example, I have used the Tfs2008 databases as the list is fairly long.  If you so desire to re-purpose this script for Tfs2010,2012,2013; simply edit the INSERT statement to resemble (keeping in mind that in my example I only have on collection DB: –Create temp table to store the Tfs Database names CREATE…

0

What’s the size of my TFS Databases?

How many times have you been caught trying to figure out what is the current size of your TFS databases? I find more often than not, just before a TFS Migration or a backup procedure, this is a very frequent ask. Here’s a nifty T-SQL Script to get your answer.   /* ============================================== — Please use judiciously…

1

How to clear the TFS cache on client machines

Every now and again when users change the version of Tfs, the client cache will need to be rebuilt. A very easy way to initiate that process is to: close all instances of Visual Studio on the client machine, manually delete the corresponding Tfs client cache folder, and then start Visual Studio The corresponding Tfs folders to…

4