Test Runs significantly add to TFS 2010 size

If you’re using the Test Run feature in Team Foundation Server 2010 you may notice that the size of your attachments (tbl_Attachment) will grow over time – there is no facility for purging or archiving.  While all the diagnostic data captured can be real handy, you probably don’t need it after some time (just look at what you can collect during a test run).

Grant Holliday has a great post explaining how to use a command line power tool known as Test Attachment Cleaner for Visual Studio Ultimate 2010 & Test Professional 2010: TCMPT.exe.  He also provides some SQL queries you can run to check the size of your attachments.

-Krip