ATTACH/DETACH SQL SERVER DATABASE FILE USING COMMAND PROPMT

GO TO 'Start - > Run ->
OPEN  THE TERMINAL [Using Command 'cmd']


sqlcmd -S <server\instance>



USE [master]
GO
CREATE DATABASE [database_name] ON
( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\<database name>.mdf' ),
( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\<database name>.ldf' )
 FOR ATTACH ;
GO

---------------------------------------------------------------------------------------------------------
To verify that the database has been attached, type the following two commands:
select name from sys.databases
go
---------------------------------------------------------------------------------------------------------

TO DETACH DB

USE master;
GO
EXEC sp_detach_db @dbname = N'AdventureWorks';
GO