Attaching & Detaching

Detach:

USE master

GO

sp_detach_db 'ApressFinancial'

Attach:

CREATE DATABASE ApressFinancial

ON (FILENAME='C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\

Data\ApressFinancial.MDF')

FOR ATTACH