To manually repair a damaged or corrupted MDF file, you can utilize the Database Console Command (DBCC CHECKDB). Keep in mind that administrator privileges are necessary to execute this command. However, this manual approach can be time-intensive and technically demanding.

For a more straightforward solution, you can use the Advanced DRS Softech MDF File Repair Tool Pro, a highly effective tool for repairing corrupt SQL MDF files. Regarded as one of the top SQL MDF recovery tools, it allows users to efficiently restore SQL database objects such as tables, triggers, indices, keys, rules, and stored procedures. To recover corrupt MDF files, follow these steps:

1. Launch the DRS Softech MDF Recovery Pro Tool and add the MDF files.
2. Choose a recovery mode and collation option, then click OK.
3. Preview all the files and click Save to recover data from the MDF file.
4. Select between Save as Database or Save as Scripts.
5. Depending on your choice, either enter server details and test the database connection or provide a location path.
6. Finally, apply any additional filters if needed and click OK to complete the recovery process.

Know More: https://www.data-recovery-solutions.com/blog/how-to-repair-mdf-files-in-sql-server-database/