Is there a way in which I can mov a databse from one server to another? I've been developing a database on my localhost, and when I come to move it online, I'll want to be able to save myself the ...

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 ...