SQL Server non-normal delete log file (LDF) recovery method

server| Recovery

The transaction log file (LDF) is deleted when the SQL Server service is not started (SQL Server cannot delete the log file while it is working), in which case the corresponding database is flagged as suspect (suspend) status after the SQL service is started

According to the current results of my experiment, the recovery method is as follows:
1, separate the suspect database, you can use the sp_detach_db
2, attach the database, you can use sp_attach_single_file_db

SQL2K can be done directly under the EM environment, if it is SQL7, you need to complete the operation in QA.

I have succeeded in several experiments under SQL Server2000
If any of the unsuccessful, please inform the detailed steps and error information to facilitate the experiment again, better solution.

The above method applies to situations where the activity log does not exist in the deleted log file and will not succeed if there are active transactions.