To recover the space occupied by TFS 2010, after deleting the artifacts.

When you delete the team project or project artifacts from TFS 2010, the TFS collection database won’t release the space occupied to store those artifacts. Even when you shrink the database file, you won’t see any change in the TPC database (.mdf) file size.

To recover the space, follow the below steps (Please wait for couple of hours to execute this command after you deleted the artifacts):

  1. Delete the team project/project artifacts.
  2. Rebuild the index on the TPC database log file using “DBCC DBREINDEX” command. This command need to be executed for each table in the database. Use a SQL cursor to execute this for all the tables in database.

    dbcc dbreindex (‘tfs_defaultcollection.dbo.Actions’)

  3. Execute the “DBCC SHRINKFILE” command on TPC database log file (.ldf) and then on data file (.mdf).

    dbcc shrinkfile (‘Tfs_DefaultCollection_log’)

    dbcc shrinkfile (‘ Tfs_DefaultCollection ‘)

  4. Now check your TPC database size, it should have reduced.


How to Prevent Users from Moving Task to Closed State with a non-Zero value Remaining Work field in VSTS/TFS

In this Blog I am going to explain how we can customize Task in VSTS/TFS to Prevent Users from Movin...

Read More >

Dashboard Migrator Tool

This is a web service which helps you to copy the VSTS dashboards from 1 team to another team easing...

Read More >

Canarys Automations Pvt Ltd recognized as finalist for 2017 Microsoft DevOps Partner of the Year Award

  Bengaluru, Karnataka, India — June 2, 2017 — Canarys Automations Pvt Ltd tod...

Read More >

Bugzilla to TFS Migrator (Part 2 of 4) – Installation

This is the second part of the Bugzilla to TFS Migrator blog series covering the installation of the...

Read More >

Bugzilla to TFS Migrator (Part 3 of 4) – Configuration

This is the third part of the Bugzilla to TFS Migrator blog series covering the configuration of the...

Read More >

Bugzilla to TFS Migrator (Part 4 of 4) - Migration

This is the final part of the Bugzilla to TFS Migrator blog series covering the actual steps of migr...

Read More >

TFS 2013 Build Template Customization

How to enable logging verbosity process parameter in build definition?Verbosity for a build will hel...

Read More >

Automating .NET builds using CCNET and TFS

CruiseControl.NET (CCNET) is an open source tool used for continuous builds on server, where testing...

Read More >

Migrating TFS 2013 Version Control to TFS Git with changeset history

There are several articles on the web describing the migration technique with minimal details. This ...

Read More >


Try DevOpSmartBoard Ultimate complete Azure DevOps End-to end reporting tool

Sign Up

  • Recent
  • Popular
  • Tag
Monthly Archive

Contact Us
  • *
  • *