SQLSERVER2008R2 MDF file Restore Database

Accidentally encountered to use MDF file restore database, tried for 2 hours to get out, Baidu found out I tried to not very good, or I did not understand.

Here is a record of my use, in case I forget.

Tools: SQL Server 2008R2

Steps:

1. Create a database with the same name as the MDF file

2. The newly created database is down (detach),

3. Find the corresponding database corpus and corresponding log corpus in the database file, delete.

4. Copy the files that need to be restored to the corresponding directory.

5. Attach the file to the database.

6, OK.

SQLSERVER2008R2 MDF file Restore Database