Attach Database

EXEC sp_attach_db @dbname = 'db', 
     @filename1 = 'C:\data\db.mdf', 
     @filename2 = 'C:\data\db.ldf'