RecoverMSSQL
From Tranzman Documentation
The following method has been tested with the versions of Microsoft SQL 2008,2012 & 2014 for recovering the Database Files and getting the server back up and running.
Step 1
Extract all database files to a temporary location on the client SQL Server as a ".BAK" type.
- i.e. "C:\Temp\New_DB.BAK"
Step 2
Log in to MS SQL Management Studio, right click on Databases and choose Restore Database.
Step 3
Select desired database form the drop down menu as the destination. For the source select From Device and point it to the BAK file on the temporary location.
Step 4
Select OK and this will restore the contents from the BAK file to the desired Database.
Use this link to go back to the main recoverydocs Page.