How to open an .MDF file? (Attach a Database in SQL Server)

[sambecker]

One of the best videos for one off technical help points that I've ever come across. I had done this before but it has been a long time and I couldn't remember. Thank you so much.

[horksurf]

Even 9 years later, this is very useful! Thanks.

[pepingsclips]

Me in 2021 finding this guy solving my problem that has been solved 9 years ago

[chenhaihu]

this video saves my life, I helped my mom in law to recovered her files succesfully, thank you

[NhatKhangHonda]

Great Thank you so much. I'm so afraid of losing data until I watch your video

[ironwomen]

This video helps ALOT. I wish I found this like an hour ago when I was struggling trying to open the .MDF doc. TYSM!

[cullenevah]

Can't believe it's that simple and easy. Thanks so much @learningsqlserver!

[teodordobrev]

Thanks, saved me a lot of time, I wanted to like the video but it seems I have liked it already a few years ago...

[halfdanox]

i have registered to thank you, cause until your video i have waste my 23 hours to solve this problem thank you indeed

[midsummer]

Thanks a million! Very clear and easy to follow. Much appreciated

[sujithkumarjack]

Excellent..it really worked to get my crashed data...👍👍👍👌👌👌

[Cronje]

Excellent, thank you for saving my sanity with this. I wish the Step by Step book for SQL was better written, it has none of this information.

[basharyounis]

That was very helpful for a SQL beginner like me. Thank you very much

[ElectroMad]

u have the greatest sql tutorials channel ever thank you :) really helpful

[janisozolins]

We swaped M57 engine In E60 where N47 originaly was and now it goes in limp mode when doing max acceleration. Driving normally looks ok. Faults we ge is 4560, 4570, 4610. Engine was driven before removal with no issues at all

[NickyKeyse]

Worked for me when I ran SQL Server Management Studio as admin. Thanks :-D

[HellfireCarnage]

You are the greatest human to have ever existed! Poets shall write songs of your brilliance! 😋 Thank you so much! Short, sweet, and EXACTLY the problem I needed to figure out. Have an amazing day!

[sammiepeeps]

Thanks so much, was stuck for a couple days on this problem!

[AngryMonkey]

or if you for any reason cant attach database, you can start new query in master database and add this code
CREATE DATABASE NewDatabase ON
(FILENAME = SQL Server Local )
FOR ATTACH

this is in my case you need to change path if your master db is in another folder and you need to copy database.mdf and log in that folder, then you type this code and that is it

[MansonMartin]

I found a way that is a lot quicker and probably more accessible to most people.

Just right click on the mdf file and choose Open With. Then pick WinRAR or a similar program and extract file content.

Done. Hope this helps.