14 พฤษภาคม 2555 5:28
I have been using an instance as a Utility Control Point to monitor 9 instances. One of the machines hosting an instance had hardware problems and the instance was moved to another machine. How can I clean up the old managed instance entry from the UCP without rebuilding the UCP?
14 พฤษภาคม 2555 5:40ผู้ดูแล
Hi, you can remove the managed instance by using the sp_sysutility_ucp_remove_mi script:
DECLARE @instance_id int; SELECT @instance_id = mi.instance_id FROM msdb.dbo.sysutility_ucp_managed_instances AS mi WHERE mi.instance_name = 'ComputerName\InstanceName'; EXEC msdb.dbo.sp_sysutility_ucp_remove_mi @instance_id;
For more info, check out http://msdn.microsoft.com/en-us/library/ee210565(v=SQL.105).aspx
Sam Lester (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.