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.
Results that may be inaccessible to you are currently showing.
Hide inaccessible resultsResults that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback