I've been able to move databases with sp_detach and sp_attach. Obviously, connections to that database will be dropped, but it shouldn't affect any others.

As an IT professional working for a small to mid-sized organization you are not only in charge of the servers, desktops, firewalls, routers, switches and mobile devices… you’re the chief, cook and ...