Open up SQL Server Management Studio and choose to Attach... database. Select the location of the primary data file (MDF). In this example the primary data file is located on E:\.
Note:
Before attaching the database be sure to set the Attach As to a different name if you are connected to the same host.
Once the database has been attached a SELECT TOP 1000 query is run to ensure we can query the database.