Restore an SQL Server database from an mdf file

1. Create a database with the same name. 2. Set the test data to offline. 3. Delete the log file test_Data.LDF. The subsequent process is not enough. 4. Log On As a Super User in the query analyzer and execute the following stored procedures. You must Log On As a Super User. This is a system-level stored procedure. EXECsp_detach_db @ dbnametestEXECsp_att

1. Create a database with the same name. 2. Set the test data to offline. 3. Delete the log file test_Data.LDF. The subsequent process is not enough. 4. Log On As a Super User in the query analyzer and execute the following stored procedures. You must Log On As a Super User. This is a system-level stored procedure. EXEC sp_detach_db @ dbname = 'test' EXEC sp_att

1. Create a database with the same name.

2. Set the test data to offline.

3. Delete the log file test_Data.LDF. The subsequent process is not enough.

4. Log On As a Super User in the query analyzer and execute the following stored procedures. You must Log On As a Super User. 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 to online.

6. Refresh the database. The table is displayed and the data is in good condition.