MS-SQL Attatch, Detach

--연결해제
ALTER DATABASE [DB 이름] SET SINGLE_USER WITH ROLLBACK IMMEDIATE

--db 분리
USE master;
GO
EXEC sp_detach_db @dbname = N'DB 이름';
GO

--db 연결
USE master;
GO
CREATE DATABASE [DB 이름]
    ON (FILENAME = 'E:\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\DB_TEST.mdf'),
    (FILENAME = 'E:\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\DB_TEST_Log.ldf')
    FOR ATTACH;
GO