Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I use the Utility Explorer to monitor some of my databases but I forgot to remove one before retiring the server. Normally, you could just right click and select "Remove Managed Instance" but I can't do that since the server has been wiped from existence. Now it is stuck in my list without any data

share|improve this question
2  
I don't have this set up to test, but what I would try is setting up Profiler to watch Management Studio, and then use the Remove Managed Instance for another server. Then grab the statements and run them for the retired server. Probably all that's needed is a cleanup of records in msdb.dbo.sysutility_* system tables. –  Jon Seigel Aug 21 '12 at 16:56
add comment

1 Answer 1

up vote 2 down vote accepted

I've recently had to drop a defunct instance from a UCP. Here's how:

DECLARE @instance_id int;

SELECT @instance_id = mi.instance_id
FROM msdb.dbo.sysutility_ucp_managed_instances AS mi
WHERE mi.instance_name = 'defunctservrname\instancename';

EXEC msdb.dbo.sp_sysutility_ucp_remove_mi @instance_id;
share|improve this answer
    
Ah, nice. Found this article which describes the whole procedure: msdn.microsoft.com/en-us/library/ee210565%28v=SQL.105%29.aspx –  Jon Seigel May 27 '13 at 19:23
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.