Restore the SQL Server database from the MDF file

1. Create a new database with the same name.

2. Set the test data offline.

3. Delete its log file test_data.ldf, do not delete the procedure behind the execution pass.

4. Log in as Superuser in Query Analyzer, execute the following stored procedure, must log in as Superuser, this is a system-level stored procedure.

exec sp_detach_db @dbname = ' test ' exec sp_attach_single_file_db @dbname = ' Test ', @physname = ' e:webdemotest_data.mdf '

5. Set the test data online.

6. Refresh the database, the table is out, the data is intact.