I have a SQL 2008 Standard server running on Windows Server 2008. The server hosts hundreds of databases. I just added 2 shiny new and fast mirrored 15,000 RPM SAS drives to the server, which are much ...

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.