SQL Server uses the MDF file to restore the database

The database accidentally lost only the MDF and LDF files.

Back up the data file and follow these steps:

1. Create a database with the same name (the data file must be consistent with the original one)

2. Stop SQL server again (do not detach the database)

3. overwrite the new database with the data file of the original database.

4. Restart SQL Server.

5. When you open the Enterprise Manager, there will be a doubt. Ignore it and execute the following statement (note that you must modify the database name)

6. After completion, You can generally access the data in the database. At this time, the database itself usually needs problems. The solution is to use
The database script creates a new database and imports the data.