How to remove UCP from SQL 2008 R2

Precautions:

This must be run from the UCP server.

User must have Sysadmin Previlages.

All managed Services must be removed from UCP before executing.

 

Execute the below

 

EXEC msdb.dbo.sp_sysutility_ucp_remove

 

If this doesn’t automatically drop the database sysutility_mdw , Drop it manually.

 

Helper : http://technet.microsoft.com/en-us/library/ff487180.aspx