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.

I've only have a redumentry background with SQL 2000 and I would like some advice. I'll get to the point. A guy has a SQL 2000 server with a database that contains a whack of information that is ...

Managing SQL Server across hybrid and multi-cloud environments has long posed a challenge for database administrators. To ...

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

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