Split a Team Project Collection
You can change the size or composition of a team project collection by splitting it into multiple collections, but this process requires that you perform many steps. These steps include creating a copy of the collection database by backing up the original collection database, restoring it using a different name, and attaching that renamed database to Visual Studio Team Foundation Server. After you restore the renamed collection database, you will have two functional team project collections in Team Foundation Server, but those two collections will still share the same reporting folder and site collection. Reporting and team project portals will continue to function, but they will not be separated from the original team project collection. You must decide whether to move any reports that are associated with the new team project collection to a separate folder, to split the site collection that hosts team project portals, or both. These changes require extra steps, but they help ensure that each collection remains a discrete unit.
You might want to split a team project collection in the following circumstances:
You want the projects in a collection to align with business units in your organization, and the projects in the collection are now owned by separate units.
You upgraded from an earlier version of Team Foundation Server, you have only one collection, and you want to organize your projects into separate collections for security or business alignment reasons.
You want to change ownership of some of the projects in the collection to a remote office that has its own deployment of Team Foundation Server. This scenario requires that you first split a collection and then move one of the resulting collections to the remote office deployment.
Note
The procedures in this topic support only splitting a team project collection. If you want to move a collection after you split it, see Move a Team Project Collection.
In this topic
To split a team project collection, you must complete the following procedures in the sequence listed:
Delete Lab Management Resources
Stop the Collection
Back Up the Collection Database
Restore the Collection Database With A Different Name
Attach the Original Collection Database
Attach the Renamed Collection Database
Reconnect SharePoint Web Application Resources
Delete Projects From the Split Collections
Split Reports
Start the Collections
Rebuild the Data Warehouse and Analysis Services
Reconfigure Team Project Portals
Configure Lab Management Resources
Configure Users and Groups for the Split Team Project Collections
Configure Users and Groups for Projects
Split the Original Site Collection to Support the Split Team Project Collections
Synchronize Integration with Microsoft Project Server
Required Permissions
To perform the following procedures, you must be a member of the following groups:
the Administrators security group on the server or servers that are running the administration console for Team Foundation
a member of the sysadmin group in SQL Server on the servers and instances that host databases for Team Foundation Server
If your deployment uses SharePoint Products, it is strongly recommended that the service account for Team Foundation Server be a member of the Farm Administrators group in SharePoint Products.
Note
You can split a team project collection without granting this membership to the service account for Team Foundation Server. However, you will see errors when you attach the collection, and you will need to perform additional steps to reconnect projects with their portals. Even if your operational requirements generally restrict granting this membership to the service account, you should consider adding the service account to the Farm Administrators group for the duration of the split operation.
In addition to these permissions, you might need to address the following requirements on a computer that is running Windows Server 2008:
To follow a command-line procedure, you might need to open an elevated Command Prompt by clicking Start, right-clicking Command Prompt, and clicking Run as Administrator.
To follow a procedure that requires Internet Explorer, you might need to start it as an administrator by clicking Start, clicking All Programs, right-clicking Internet Explorer, and then clicking Run as administrator.
To access SharePoint Central Administration, Report Manager, reports, or Web sites for SQL Server Reporting Services, you might need to add these sites to the list of trusted sites in Internet Explorer.
For more information, see the following topic on the Microsoft Web site: User Account Control.
Delete Lab Management Resources
You can skip this procedure if either of the following conditions is true:
The team project collection that you are splitting is not configured for Visual Studio Lab Management
You are splitting the team project collection within the same domain and intend to use the same System Center Virtual Machine Manager (SCVMM) that previously supported the collection.
If you are moving the collection to a different domain or intend to use a different System Center Virtual Machine Manager, you must delete, from the collection database, the resources that Lab Management uses. These resources include virtual machines, templates, team project host groups, and team project library shares. You will need to re-create the Lab Management assets after you restore and attach the collection.
To delete the Lab Management resources
- For information about how to remove all group hosts, library shares, and environments from a specified team project collection, see TFSConfig Lab /Delete Command with the /External option.
Detach the Collection
Before you split a collection, you must first detach it from the deployment of Team Foundation Server on which it is running. When you detach a collection, all jobs and services are stopped, and then the collection database is stopped.
To detach a team project collection
Open the administration console for Team Foundation on the server that hosts the collection that you want to split.
For more information, see Open the Team Foundation Administration Console.
Click Team Project Collections, and in the list of collections, click the collection that you want to split.
On the General tab, click Detach Team Project Collection.
The Detach Team Project Collection Wizard opens.
(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.
Click Next.
On the Review settings that will be used to detach team project collection page, review the details.
If you want to changes any settings, click Previous. If they appear to be correct, click Verify.
When all the readiness checks have completed successfully, click Detach.
On the Monitor the team project collection detach progress page, when all processes have completed, click Next.
(Optional) On the Review supplemental information for this team project collection page, click or note the location of the log file.
Click Close.
The team project collection no longer appears in the list of collections in the administration console.
Back Up the Collection Database
After you have detached the collection, you must back up its database to restore a copy to the server with a different name. To perform this task, you must use the tools that are provided with SQL Server.
To back up a collection database
- For information about how to manually back up and restore individual databases, see the following page on the Microsoft Web site: Backing Up and Restoring Databases in SQL Server.
Restore the Collection Database
As part of splitting the collection, you must restore the backup of the collection database to an instance of SQL Server that is configured to support the deployment of Team Foundation Server. When you restore the database, you must give it a different name from the name of the original collection database.
To restore the collection database with a new name
- For information about how to manually back up and restore individual databases, see the following page on the Microsoft Web site: Backing Up and Restoring Databases in SQL Server.
Attach the Original Collection Database
After you have restored the database with a different name, you must reattach the original collection database to the deployment of Team Foundation Server.
Note
Warnings will appear when you attach the collection if your deployment uses SharePoint Products and the service account for Team Foundation Server is not a member of the Farm Administrators group. This behavior is expected.
To attach the collection
Open the administration console for Team Foundation.
Click Team Project Collections, and then click Attach Team Project Collection.
The Attach Team Project Collection Wizard opens.
On the Select the team project collection database to attach page, in SQL Server Instance, type the name of the server and the instance that hosts the collection database, if it is not already listed.
In the Databases list, click the collection database that you want to attach, and then click Next.
On the Enter the team project collection information page, type a name for the collection in Name if one is not already present.
(Optional) In Description, type a description of the collection.
Click Next.
On the Review settings that will be used to attach the team project collection page, review the information.
If you must change any settings, click Previous. If all the settings are correct, click Verify.
When all the readiness checks have completed successfully, click Attach.
On the Monitor the team project collection attach progress page, when all processes have completed, click Next.
(Optional) On the Review supplemental information for this team project collection page, click or note the location of the log file.
Click Close.
The team project collection appears in the list of collections in the administration console.
Attach the Renamed Collection Database
After you attach the original collection database, you must attach the renamed collection to the deployment of Team Foundation Server. When this collection is attached, it will remain stopped. You will not be able to start it until all duplicate projects have been removed.
Note
Warnings will appear when you attach the collection if your deployment uses SharePoint Products and the service account for Team Foundation Server is not a member of the Farm Administrators group. This behavior is expected.
To attach the renamed collection database
Open the administration console for Team Foundation on the server that hosts the application tier for the deployment that will host the split collection.
Click Team Project Collections, and then click Attach Team Project Collection.
The Attach Team Project Collection Wizard opens.
On the Select the team project collection database to attach page, in SQL Server Instance, type the name of the server and the instance that hosts the renamed collection database, if it is not already listed.
In the Databases list, click the renamed collection database, and then click Next.
On the Enter the team project collection information page, type a name for the renamed collection in Name that differs from the name of the original name of the collection.
(Optional)In Description, type a description of the collection.,
Click Next.
On the Review settings that will be used to attach the team project collection page, review the information.
If you must change any settings, click Previous. If all the settings are correct, click Verify.
When all the readiness checks have completed successfully, click Attach.
On the Monitor the team project collection attach progress page, when all processes have completed, click Next.
Note
If the collection is supported by a SharePoint Web application, a warning icon will appear for the attach status of the SharePoint Web application. This behavior is expected, and you can ignore it.
(Optional) On the Review supplemental information for this team project collection page, click or note the location of the log file.
Click Close.
The name of the collection appears in the list of collections in the administration console.
Reconnect Resources for the SharePoint Web Application
After you attach the renamed collection, you must repair the connection to the SharePoint Web application to ensure that all connections are correctly set between the renamed collection and the Web application.
To repair the connection to a SharePoint Web application
Open the administration console for Team Foundation on the server that hosts the application tier for the deployment to which you want to move the collection.
Click SharePoint Web Applications, and in the list of Web applications, click the Web application that supports the collection that you just attached.
The Repair Connection button appears after you select a Web application in the list.
Click Repair Connection, and in the Repair the connection to a SharePoint Web Application dialog box, click Reconnect.
When the Status window reports Reconnect operation succeeded, click Close.
Delete Projects on the Split Collections
Now that you have two copies of the collection attached to Team Foundation Server, you must delete each project from either the original collection or the renamed collection so that no project remains in both collections.
Important
A project cannot exist in more than one collection. Until you delete all duplicated projects between the split collections, you will not be able to start the renamed collection.
To delete projects from the collections
Open the administration console for Team Foundation on the server that hosts the split collections.
Click Team Project Collections, and in the list of collections, click the collection that you stopped in order to split it.
Click the Team Projects tab.
In the list of team projects, click a project that you want to delete from the collection, and then click Delete.
The Delete Team Projects dialog box opens.
Select the Delete workspace data check box, leave the Delete external artifacts check box cleared, and then click Delete.
If the Delete external artifacts check box is not cleared and your team project is configured to use Lab Management, the virtual machines and templates that are associated with the project will be deleted from System Center Virtual Machine Manager. They will no longer be available to the team project in the renamed collection.
Repeat steps 2-5 until both collections contain a set of unique projects.
Split Reports
You can skip this procedure if your deployment does not include a server that is running SQL Server Reporting Services or if you do not want to split reports into folders that reflect the separate collections.
After you delete projects, you must move the reports that the split collection uses into a different folder, and you must delete them from the original folder.
Important
The report folders exist in both locations. Make sure that you move all reports appropriately before you delete any report folders.
To split reports into separate folders
In Report Manager, move the reports that support the split collection into the appropriate folders for that collection.
For more information, see the following topic on the Microsoft Web site: Move Items Page.
If your deployment utilizes a SharePoint Web application, you might need to reconnect it after you move the reports before they will appear correctly. You can reconnect the Web application by performing the following steps:
Open the administration console for Team Foundation on the server that hosts the split collection.
Click SharePoint Web Applications, and then click the application that supports the collection.
The Reconnect SharePoint Web Application button appears after you select a Web application in the list.
Click Reconnect SharePoint Web Application, and in the Reconnect a SharePoint Web Application to Team Foundation Server dialog box, click Reconnect.
When the Status window reports Reconnect operation succeeded, click Close.
Start the Team Project Collections
After you delete projects, you must restart the renamed collection before you can configure users and groups for both of the split collections.
To start a team project collection
Open the administration console for Team Foundation on the server that hosts the split collections.
Click Team Project Collections, and in the list of collections, click the collection that you stopped in order to split it.
On the General tab, click Start Team Project Collection.
The collection starts.
Repeat step 2 for the collection that you attached with a new name.
Rebuild the Data Warehouse and Analysis Services
You can skip this procedure if you are not using a server that is running Reporting Services as part of your deployment.
If the deployment on which you have split a collection uses a report server, you must rebuild the warehouse for Team Foundation and the database for Analysis Services. You must perform this step to ensure that reports and dashboards work correctly for the deployment after you split the collection and that no conflicts occur with other collections in the deployment.
To rebuild the data warehouse and the Analysis Services database
Open the administration console for Team Foundation.
In the navigation bar, click Reporting.
In Reporting, click Start Rebuild.
In the Rebuild the Warehouse and Analysis Services Databases dialog box, click OK.
Note
The warehouses will continue to be rebuilt and the data will continue to be repopulated after the Start Rebuild action finish. Depending on the size of your deployment and the amount of data, the whole process might take several hours to complete.
Reconfigure Team Project Portals
You can skip this procedure if your deployment does not use SharePoint Products.
After you start both collections, you must reconfigure the team project portals for projects in each collection so that those portals reflect the correct data for those projects.
To reconfigure team project portals
Open Team Explorer, configure the URL for the SharePoint site, and make sure that the Reports and dashboards refer to data for this team project check box is selected.
For more information, see Add a Team Project Portal and Connect a Microsoft Office Document to Team Foundation Server.
Configure Lab Management Resources
You can skip this procedure if you split the team project collection in the same domain and intend to use the same System Center Virtual Machine Manager (SCVMM) that previously supported the collection.
If you moved the collection to a different domain or intend to use a different System Center Virtual Machine Manager, you must recreate team project host groups. You must also recreate team project library shares in Team Foundation Server and the virtual machines, templates, and environments in Microsoft Test Manager.
To configure Lab Management resources
Configure the application tier for Team Foundation.
For more information, see Configuring Lab Management for the First Time.
Recreate the golden master virtual machines and templates in the new SCVMM.
For more information, see How to: Create and Store Virtual Machines and Templates Ready for Lab Management.
Import the virtual machines and templates into the team project collection
For more information, see How to: Import a Virtual Machine or a Template from SCVMM.
Recreate the environments for each team project.
For more information, see How to: Create an Environment from Virtual Machines or Templates.
Configure Users and Groups for the Split Team Project Collections
You can skip this procedure if both split collections will remain in the same domain and you want to allow access for the administrators of the original collection to both collections.
After you have split a collection, you must update the permission groups for both collections with users and groups that will administer those collections.
To configure users and groups for the collections
- For more information, see Set Administrator Permissions for Team Project Collections.
Configure Users and Groups for Projects
You can skip this procedure if the split collections will remain in the same domain and you want to allow access for the users of projects in the original collection to both collections.
After you configure administrators for the both collections, either you or those administrators must configure access for users and groups to the projects in each collection. Depending on your deployment, you might also need to configure permissions for those users in SharePoint Products and Reporting Services.
To configure access for users to team projects
- For more information, see Add Users to Team Projects.
Split the Original Site Collection to Support the Split Team Project Collections
You can skip this procedure if your deployment does not use SharePoint Products or if you would rather continue to use the original site collection to support both team project collections.
You can continue to use the same site collection in SharePoint Products to support both split collections. Team projects in both collections will use the same team project portals as before. All portals are hosted on the site collection that supported the original team project collection. However, this configuration not only complicates the one-to-one relationship between a team project collection and a site collection but also makes restoring your deployment potentially more difficult. To avoid this complexity, you can split the site collection that supported the original team project collection to reflect the split that you made for the team project collections.
To split the site collection and redirect the split team project collections to use the split site collections
For information about how to split a site collection, see the following pages on the Microsoft website:
For Windows SharePoint Services 3.0, see Move site collections to a new database (split a content database).
For Microsoft Office SharePoint Server 2007, see Move site collections to a new database (split a content database).
For Microsoft SharePoint Server 2010, see Move site collections between databases.
Tip
Make sure that you configure user permissions and access to the site collections to match the user access to the team project collections.
Configure any affected team project collection to utilize the split site collection.
For more information, see Managing Settings for SharePoint Sites.
Reconfigure the team project portals for team projects in each collection so that those portals reflect the correct data for those projects.
For more information, see Reconfigure Team Project Portals.
Synchronize Integration with Microsoft Project Server
You can skip this procedure if the team project collection that you are splitting is not integrated with Microsoft Project Server. For more information, see Microsoft Team Foundation Server 2010 and Microsoft Project Server Integration Feature Pack.
You do not need to take any steps to continue synchronizing data between the collection and Project Server after you have split the collection unless you also plan to move the collection to a different server. In that case, you must follow the steps for moving a collection after you split the collection. For more information, see Move a Team Project Collection.
After you split your team project collection, you must wait for the metadata to update as part of the synchronization between Team Foundation Server and Microsoft Project Server. After synchronization, your data should appear correctly in Project Server. For more information, see Changing the Configuration of Your Deployment.
To verify synchronization
After you have split a collection, wait for the data to synchronize. This process happens automatically on a predetermined schedule. For more information, see Overview of the Synchronization Process for Team Foundation Server and Project Server Integration.
If one of the split collections will no longer synchronize with Project Server, unmap it by using the TFSAdmin ProjectServer /UnmapPWAFromCollection command with the /force option.
For more information, see Mapping a Team Project Collection to an Instance of PWA, Changing the Configuration of Your Deployment, and Removing a Component from Participating in Data Synchronization.
See Also
Tasks
Create a Team Project Collection
Move a Team Project Collection
Concepts
Team Foundation Server Architecture
Interactions Between SharePoint Products and Team Foundation Server