I am decommissioning one of our SQL servers.  I want to remove it from solidcp, but I cant because there are hosting spaces where it is a service.  However, no hosting spaces are actually using the service, ie there are no databases on this server.  From the forum I see I am supposed to delete and recreate the hosting spaces for my users.  This is seems like a lot of work.  If I delete a hosting space, doesnt that delete all the data the client is using, ie if they have exchange organizations would I have to recreate them and all the mailboxes etc just to remove this SQL server.  We have other SQL servers.  Is it possilbe to manually just remove the service / old server from hosting spaces in the database?  ie something akin to remove FROM PackageServices WHERE Service id= ‘id of sql server service to remove’?

Answered question