Here I Would like to introduce another excellent third party software, Kernel for SQL Recovery. The software is capable to retrieve data from MDF and NDF file of MS SQL Server.
Its free demo version is also available to download at- https://www.kerneldatarecovery.com/sql-recovery.html