Do you have requirement to know about how to restore user .mdf file which are out-of-the-way? Use SQL recovery software to execute it task, because the software is able to repair & recover database such as triggers, stored procedures, views etc. from corrupted or damaged SQL Server MDF file and then restore MDF file data directly in SQL Server.