–HostId ParentHostId Name Description VirtualDirectory ResourceDirectory Status StatusReason SupportedFeatures LastUserAccess Authority HostType DatabaseId
–79C310BE-8696-4B59-BC5A-CDDE3C41C47B NULL TEAM FOUNDATION NULL NULL NULL 1 NULL 0 2015-06-01 02:23:32.753 NULL 3 1

–Update [Tfs_Configuration].[dbo].[tbl_ServiceHost]
–SELECT * FROM [Tfs_Configuration].[dbo].[tbl_ServiceHost]
–SET [Tfs_Configuration].[dbo].[tbl_ServiceHost].[HostId] = ‘c17bad41-69e5-4a2d-96cf-a3ae0b5c3d98′
SET [Tfs_Configuration].[dbo].[tbl_ServiceHost].[HostId] = ’79C310BE-8696-4B59-BC5A-CDDE3C41C47B’
WHERE Name = ‘TEAM FOUNDATION’

–Update [Tfs_Configuration].[dbo].[tbl_ServiceHost]
–SELECT * FROM [Tfs_Configuration].[dbo].[tbl_ServiceHost]
SET [Tfs_Configuration].[dbo].[tbl_ServiceHost].[ParentHostId] = ’79C310BE-8696-4B59-BC5A-CDDE3C41C47B’
WHERE [Tfs_Configuration].[dbo].[tbl_ServiceHost].[ParentHostId] = ‘c17bad41-69e5-4a2d-96cf-a3ae0b5c3d98’

Advertisements