Note Check out the for an introduction to restoring data on the same server for TFS. SharePoint integration with TFS is deprecated after TFS 2017. Prerequisites To perform this procedure, you must be a member of the following groups or have the following permissions: • A member of the Administrators security group on the server or servers that are running the administration console for Team Foundation. • Either a member of the SQL Server System Administrator security group or your SQL Server Perform Back Up and Create Maintenance Plan permission must be set to Allow on the instance of SQL Server that hosts the databases. • A member of the sysadmin security group for the database instance for Team Foundation and for the Analysis Services instance of the warehouse database. • An authorized user of the TFS_Warehouse database. Jul 09, 2006 I think that my next few posts will be about the Team Foundation Server Data Warehouse, so I wanted to do a post about how to update this warehouse. When used in an extensible scenario, these alerts can be sent to a web service, triggering actions to alter or update work items (such as implementing advanced business rules or generating work items programmatically based on a given scenario). The data warehouse can also be extended through the creation of custom. Mar 18, 2011 - By default, TFS will process it's Data Warehouse and Analysis Services Cube (and thus update the data for the reports) every 2 hours. You can change the default frequency or manually invoke cube processing, if needed. Be careful with changing it to lower values than every hour: Important. If you reduce. Team Foundation Server 2015 Update 4 Release Notes. Work item tracking warehouse sync fails with a name conflict when field names only differ by a space replacing. TFS Warehouse is not updating. Furthermore, before one week I change the system date to 1/1/2055 and update the TFS warehouse on demand. • A member of the TFSEXECROLE database role. • If the deployment uses SharePoint Products, a member of the Farm Administrators group for the farm to which the SharePoint Products databases are being restored. For more information, see the following page on the Microsoft website:. Step 1: Stop services that TFS uses Stopping the services helps protect against data loss or corruption during the restoration process, particularly if you rename databases. • On the server that is running the application-tier services for Team Foundation, open a Command Prompt window, and change directories to Drive:%programfiles% TFS 12.0 Tools. • Type the following command: TFSServiceControl quiesce For more information, see. Step 2: Rename Databases that You Want to Restore Before you can use the Restore wizard to restore a database that Team Foundation Server, you must first take it offline, and then rename it. To stop databases that Team Foundation Server uses • Open SQL Server Management Studio. Note: For more information about how to restore databases, see the following page on the Microsoft website:. The Connect to Server dialog box opens. • In Server type, choose Database Engine. • In Server name, choose or type the name of the data-tier server and database instance, and then choose Connect. Note: If SQL Server is installed on a cluster, the server name is the name of the cluster and not the computer name. SQL Server Management Studio opens. • Expand the Databases node to show the list of databases that make up the data tier for Team Foundation. • Rename and then stop each database you want to restore, following. Give the database a name that indicates it is the old version of the database you will replace with the restored version. For example, you might rename TFS_DefaultCollection to TFS_DefaultCollection_Old. Step 3: Restore Team Foundation Databases You can restore data for Team Foundation Server by using the Restore wizard in the administration console in TFS. The Restore wizard also restores the encryption key used for reporting. To restore databases • Open the administration console for TFS and navigate to Scheduled Backups to start the Restore wizard. • Specify the path to the backup set and choose the set you want to use for restoration. • Complete the wizard and restore the databases. Step 4: Update All Service Accounts You must update the service account for Team Foundation Server (TFSService) and the data sources account (TFSReports). Even if these accounts have not changed, you must update the information to ensure that the identity and the format of the accounts are appropriate. To update service accounts • On the server that is running SQL Server Reporting Services, open Computer Management, and start the following components if they are not already started: • ReportServer or ReportServer$ InstanceName (application pool) • SQL Server Reporting Services ( TFSINSTANCE) • On the application-tier server, open a Command Prompt window, and change directories to Drive:%programfiles% TFS 12.0 Tools. • At the command prompt, enter the following command to add the service account for Team Foundation, where DatabaseName is the name of the configuration database (by default, TFS_Configuration): TfsConfig Accounts /add /AccountType:ApplicationTier /account: AccountName For more information about how to use this command, see. • Use the Accounts command to add the data sources account for the report server and the proxy account for Team Foundation Server Proxy, if your deployment uses these resources. Step 5: Rebuild the Warehouse You can rebuild the data warehouse instead of restoring the TFS_Warehouse and TFS_Analysis databases.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
July 2018
Categories |