Database Attach failed Error 5172

Share a very common error today, database attach failed, error 5172

Wrong operation to delete SQL database, (no backup)

Use the hard drive data recovery tool software to retrieve the data document Htaidata_log from the hard drive. MDF and Htaidata_log. LDF document and resume.

Htaidata_log the data document. MDF and Htaidata_log. LDF Copy to C:

Attach the database in Enterprise Manager and select Htaidata_log. The LDF error message appears as follows:
Server: Msg 5172

File ' C:\HTaiData_log. The file header for LDF is not a valid database file header Pageaudit property is incorrect.
Data recovery was unsuccessful. ：

Solution Solutions

(1). Delete log files

(2), and then attach the database

Enterprise Manager--database--Right-click Database--All tasks--attaching a database this time only MDF is attached

Database Attach failed Error 5172