How to recover database from MDF in SQL Server 2008 R2
Thu, 14 Aug 2014

Select SQL Server Management Studio

Connect to the Server

Rightclick on Databases

select Attach

Click Add

and navigate to MYSQL directory path    e.g  C:\Program Files\Microsoft SQL Server\MSSQL10_50.LOCALHOST\MSSQL\DATA\.mdf

Select the .mdf file and click ok

Confirm the location of your .mdf and .ldf

Click ok

Done The Test database has been recovered

comments powered by Disqus