Delete a Team Project Collection

You can delete team project collections that are no longer being used in your deployment of Visual Studio Team Foundation Server. By deleting a collection, you ensure that users do not accidentally connect to it and work on projects within that collection, and you help simplify your deployment.

To delete a collection, you must first detach it from Team Foundation Server. However, if you detach a collection, you do not delete the database for the collection from SQL Server. To truly delete a collection, you must then manually delete the database for the collection from the SQL Server instance that hosts the collection database. Similarly, if you detach a collection, you do not delete the SharePoint site collection that hosted the team project portals for projects in that collection. To delete those portals, you must also delete the site collection that supported that collection.


Ideally, each site collection supports only one team project collection, but it is possible for more than one collection to use the same site collection. You should verify that the site collection is not used by any other team project collection or for any other purpose before you delete the site collection.

You do not need to delete the database or the site collection, but the collection will not be truly deleted until you complete these steps. If you are deleting a collection for performance or space considerations, you should consider manually deleting the database from SQL Server and the site collection from SharePoint Products after you detach the collection.


You can delete a team project collection at a command prompt by using the TFSConfig Collection command. Unlike deleting a collection from the administration console, when you use the TFSConfig Collection tool, you permanently remove any chance of reattaching the collection database. For more information, see Collection Command.

Required Permissions

To perform the following procedures, you must be a member of the following groups:

  • a member of the Administrators security group on the server or servers that are running the administration console for Team Foundation

  • a member of the sysadmin group on the server or servers that are running the instance of SQL Server that hosts the databases for Team Foundation Server

  • a member of the Farm Administrators group for the farm from which you are deleting the site collection, if your deployment uses SharePoint Products

For more information, see Team Foundation Server Permissions.

To delete a team project collection

  1. If your deployment is integrated with Microsoft Project Server 2007 with Service Pack 2 (SP2) or Project Server 2010, you must unmap the team project collection from Project Server before you delete the collection. To make this change, you must use the TFSAdmin ProjectServer /UnmapPWAFromCollection command with the /force option. For more information, see Mapping a Team Project Collection to an Instance of PWA and Microsoft Team Foundation Server 2010 and Microsoft Project Server Integration Feature Pack.

  2. Open the administration console for Team Foundation.

    For more information, see Open the Team Foundation Administration Console.

  3. Under Team Foundation, expand the name of the server, expand Application Tier, and then click Team Project Collections.

  4. In the list of collections, click the name of the collection that you want to delete.

  5. On the General tab, click Detach Team Project Collection.

    The Detach Team Project Collection Wizard opens.

  6. (Optional) On the Provide a servicing message for the team project collection page, in Servicing Message, type a message for users who might try to connect to projects in this collection.

  7. Click Next.

  8. On the Review settings that will be used to detach team project collection page, review the details.

  9. If you want to change any settings, click Previous. If they appear to be correct, click Verify.

  10. When all the readiness checks have completed successfully, click Detach.

  11. On the Monitor the team project collection detach progress page, when all processes have completed, click Next.

  12. (Optional) On the Review supplemental information for this team project collection page, click or note the location of the log file.

  13. Click Close.

    The team project collection no longer appears in the list of collections in the administration console.

  14. Open SQL Server Management Studio, connect to the instance of the SQL Server Database Engine that hosts the collection database, and expand the instance.

  15. Click the name of the collection database (by default, TFS_CollectionName), and then delete the database.

    For more information, see the following page on the Microsoft Web site: How to: Delete a Database.

  16. Open SharePoint Central Administration, and delete the site collection that supported the deleted collection.

    For more information, see the following page on the Microsoft Web site: Delete a Site Collection (Windows SharePoint Services 3.0) or Delete a Site Collection (Microsoft Office SharePoint Server 2007).

See Also


Create a Team Project Collection

Modify a Team Project Collection


Team Foundation Server Architecture

Interactions Between SharePoint Products and Team Foundation Server

Change History




March 2011

Added information about deployments that integrate with Project Server.

SP1 feature change.