Attaching and Detaching a Database SQL

Attaching and Detaching a database will be very much helpful to move around database files.

Detach:

Go EXEC sp_detach_db @dbname = N'Adventure Works'

Attach: 

Using SP:

USE [master]
GO
EXEC sp_attach_db @dbname = N'AdventureWorksLT2012',
@filename1 = 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\AdventureWorksLT2012_Data.mdf',
@filename2 = 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\AdventureWorksLT2012_log.ldf'
GO

Using T-SQL:

Create Database <Database name>

USE [master]

GO

CREATE DATABASE [AdventureWorksLT2012] ON 

( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\AdventureWorksLT2012_Data.mdf' ),

( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\AdventureWorksLT2012_log.ldf' )

 FOR ATTACH

GO