I have a server that we upgraded an application running sql and after the upgrade it is a real dog.
our solution is to run that application on a dedicated server. What I want to try is to make a duplicate of our production server, to test, and strip off all the other roles it has. Currently this server does it all, runs ad, terminal services, dns, dhcp, another ads database, and several other programs.
How do i "strip off" all these other roles that the server is running and only run this one sql application?