If you need to solve this without any loss problem and want to recover it firmly as well as to remove such corruption issue from the MS SQL Server database, then you can optimized external tool to retrieve all data from corrupt SQL MDF and NDF files as well as export it directly to SQL Server.