Taking a Database Offline - SQLServerCentral

Quick Tip: Taking a Database Offline - SQLServerCentral: "Quick Tip: Taking a Database Offline

An interesting database option which is hidden from Enterprise Manager in SQL Server 7.0 is offline.

The offline option as it sounds, simply takes a database offline.

Often DBAs take database offline instead of placing them in single user mode to see if anyone is using the database.

The main reason you would use the offline option however is to transport the database.

You can place the database offline, then copy the .MDF and .LDF files to the destination server and then attach them.

This is used in place of the sp_detachdb system stored procedure."