Only the method attached to the SQL database of the MDF file

1. Create a database with the same name
2. Modify Server Settings: allow direct modification to the directory of multiple systems
3. Stop SQL Server
4. overwrite the database file of the new database with the original MDF file
5. Restart SQL Server (in this case, the database should be in doubt)
6. Set the database to an emergency: Update master. DBO. sysdatabases set status = 32768 where name = dbname
7. Rebuild the log: DBCC rebulid_log ('dbname', 'logfile') (this step may not be required .)
8. Restart the database and restore the database status. Use the following statement.
Update master. DBO. sysdatabases set status = 16 Where name = dbname