Attach a database file to SQL Server

If you have a SQL Server Database file (.mdf) and the associated logfile (.ldf), you can attach this manually to an SQL Server database.

Here's a Microsoft link explaining the process:

http://msdn.microsoft.com/en-us/library/ms165673.aspx