1.2 How to download and import AdventureWorks database | SQL Server Tutorial

AdventureWorks database is a sample database provided by Microsoft that comes with SQL Server. For new SQL Server users who don’t have any data to work with, AdventureWorks database provides a really good learning material. In MS SQL Server, you can import the backup database file (AdventureWorks.bak file) in two ways. One is the manual import using the SQL Server backup import wizard. The other way is to execute T-SQL statements. Unless you have very specific configuration settings otherwise, using the import wizard is probably the easiest way to import a backup database file.
In this tutorial I will teach you step-by-step how to import the SQL Server database backup file.
If you don’t have SQL Server installed, please watch my tutorial video how to install MS SQL Server Express ( • 1.1 How to install Mic... ) for instruction how to install SQL Server.
Link to download AdventureWorks database file: github.com/Mic...
► Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------
☕ Paypal: www.paypal.me/...
☕ Venmo: @Jie-Jenn
💸 Join Robinhood with my link and we'll both get a free stock: join.robinhood...
► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------
🌳 Becoming a Patreon supporter: / jiejenn
🛒 By shopping on Amazon → amzn.to/2JkGeMD
🗓 Get updated on new Python videos → / madeinpython
📘 More tutorial videos on my website → LearnDataAnaly...
📺 Also check out my 2nd channel Excel channel focus on sharing Excel tips: bit.ly/3B1DjSA
✉ Business Inquiring: [e-mail]

[@barigbonyieikagbara4367]

I usually don't post or comments on things online, but you deserve this. Thank you so much. I was having a very hard time installing AdventureWorks 2012 for my class and I was getting frustrated. Following your video help successfully install it and run it. God bless you.

[@javi1565]

Spent couple hours stuck, then your video helped me out in 6min - thank for the step by step walk through!!

[@abu1479]

Thank you for the video. I was struggling to download the Adventure Works file until I watched your video. Thanks for walking us through all the steps.

[@foucault9978]

You're a legend! The Microsoft instructions are absolutely useless if you're not familiar with the software and what you're doing, and nobody else online was able to explain how to do this as well as you. Thank you

[@jiejenn]

Glad my video helped.

[@JayRevealer]

wow man.. I was so fucked trying to work out the .mdf and log file of adventure works and downloaded a ton of shit and nothing worked... but this...this really worked..thanx man

[@nicolelin9435]

Thank you! I'm able to import a microsoft sql server product samples database within 2 min just by following your tutorial! Appreciate your effort to create these valuable videos!

[@phillipmontague4407]

Thank you so much, had many difficulties with this until watching your video! Cheers!

[@mediatripai9880]

Your short and concise tutorial is brilliant. I'm in agreement with all the praise you've already received!

[@dp6736]

Thank you very much for a very basic but useful tutorial. I wasted about two hours before watching your video. God bless you.

[@jameshouston8400]

Finally! It was so hard to find a straight forward video when came to this, my teacher is absolutely worthless compared to you. Mucho Love

[@beatricesalazar401]

Thanks Jenn, I was able to add the Adventure Works 2017 database file following your instructions.

[@Anand_Sriram]

Thanks for the video Jie, this video really impressed me to write a comment for the first time in TH-cam.

[@mohammadsi678]

Thank you so much Jenn, as your instruction, successfully added the Adventure Works 2012 database file, I would highly appreciate your great support, GOD bless you.

[@Fkn1405]

Thank you Jie Jenn! Nice video, goes straight to the point.

[@yOURCHRIST]

Good lord, thank you so much. Why isn't it automatically told to put it in this folder on Microsoft's install site. Seriously, this should be the exact way they are teaching it. Thank you so much again!

[@melr4353]

Thanks so much ! Very helpful, direct to the point , no fancy intros & easy to follow.

[@kylenelson7948]

Thank you you are the only person who was able to help me add this sample database.

[@craigsilverman1826]

Thank you so much for posting, Jie Jenn. This was extremely helpful as I was so lost on how to get the database up and running. Thank you

[@patrickkelley9057]

Very helpful and easy to follow along. Thank you for sharing this tutorial.

[@PrincessEvilGenius]

If only I could have found this about three hours ago...please enjoy your coffee! Hugs to you too!

[@jiejenn]

Thank you for the coffee, and glad my video helped!

[@tchreekdavenport5504]

Was having difficulties with C:drive. Had to use D: drive on newer laptop running Windows 10. Thanks!

[@oscarayang9825]

Well done. Very simple and straightforward steps. Highly appreciated

[@Macspt]

Video instructions worked exactly. Nice job!

[@AO_Rourke]

Thank you for making this so straight forward

[@jblowers62]

Thanks for posting this! Easy straight forward and to the point.

[@krishnabala8403]

Thank you! That was easy to follow and install! Very helpful.

[@williamkazenas8193]

Thank you so much. No BS. Just results.

[@adeolabamigboye4393]

wow...thanks..so simple and straight forward.

[@MyWorld-st9qc]

Thank you so much, this was very helpful, keep up the good work.

[@shubhamsahai2492]

Thank you for this video! I was able to successfully install the AdventureWorks database!

[@vickarkhan]

Thank you very very much for such an easy guide to restoring a backup file. Microsoft has provided the backup files but unfortunately I couldn't find clear documentation on restoring these backup files in SSMS. thanks once againg

[@usafvet2010]

Thank you so much. This was very helpful. I greatly appreciate it

[@granand]

Hey Jie Jenn, very useful. Have you left us here or taking forward in a journey to teaching us Database and writing complex scripts of TSQL, Inserting data, creating reports etc

[@ruchiparihar8422]

simple easy steps...Uploaded database for the first time .. Sucessfully..

[@GNUSupporter]

Thx so much. I had the bak file on a different drive (Z:\), and I got an error. Thx 2 ur video, I now know that the bak file has to be placed under the specific Backup folder in Program Files.

[@jiejenn]

Glad my video helped.

[@healthylife7140]

Thank you sir for you video it is very helpful and more interesting than other videos

[@akashsubramaniam]

Thanks a lot looking for a solution from the past 2 hrs and finally got 1 Works like a charm :D

[@ufak_tefek]

I say thank you so much bro because I spend many time fot it and start thinking crush my pc :)

[@norbertomdemelo225]

Thanks, Very useful!

[@oladapoabdullahi]

Thanks so much,your explanations is very easy......you're the best

[@richardoliyon9042]

This is awesome! Many thanks and keep up the good work teaching

[@shamaparween7655]

Thanku so much.. Always such a type of idea for little problem

[@AA-qc4zl]

Great work bro u saved my weekend ✓ thanks alot

[@tewodrosnahto2700]

Thank you, i can connect SQL server engine now

[@jaeen7665]

Worked like a charm. Thanks much.

[@jesusislord2484]

thank you very much i really do appreciate our good work

[@sowmyakrishnam1444]

Thank you soo much now am able to restore the adventure works database ..

[@whatskrakalaken1940]

This was excellent, thank you.

[@bhadreshkaratela8478]

This was nice and easy..Thank you

[@avanirana33]

Thank you so much! very helpful!

[@joaomonteiro663]

Very well explained. Worked perfectly. Thanks

[@honoreetekpo5082]

Very Helpful and easy to follow. Thanks

[@gislentim8425]

thanks for the video, this was really helpful

[@adamoumagaji17]

oooh my God thanks so much.i did install the 2016 on my own but when i tried all day with the 2014 i was unable to. thanks so much

[@jiejenn]

Glad my video helped.

[@aphex179]

Thank you! helped a lot. i use MS SQL Server express

[@staticsock]

Simple and too the point. Thank you very much!!!!

[@simplyjudith23]

Very very helpful thank you!

[@Desi_american]

Thank you so much for this video, I am sure I should be able to add adventure work succesfuly, only that i am getting a message on the last step "verify backup media" . my bak files are getting downloaded with either internet explorer icon or word icon (different from what i see in this ) video which seems to be the problem. please help me rectify this

[@marisonperez3257]

You are the best! Thank you so much! :)

[@rdcsqualus]

This is awesome!
Thank you!

[@911419834]

Thank you man, appreciated your help!

[@ChidoChamapiwa]

Nice. So helpful.

[@mrunaliniayyagari9284]

Thank you so much for guiding. It helped me a lot. Keep going

[@kaurkaur9258]

Thank you so much its very useful while studying _/\_

[@121clicks]

thank u so much..it was very helpful to me and successfully installed and added adventureworks database

[@mingchauwen2669]

thank you so much for such a clear and easy understand tutorial video!~

[@furtunahab4441]

thank you,it was helpful.

[@Kokanexplorerpoonam]

great video thank you so much sir ...
from MY INDIA ...

[@charismaOriana]

GOD bless you. Thank you. I'm greateful.

[@pollycrilly6842]

Very Good !

[@marcmason3514]

I cannot find the folder you pasted the .bak file into on your computer. In my SQL Server folder I am missing the folder you pasted into. Where should I paste this to?

[@prianthagovender649]

I would have lost hope if it wasnt for videos like these, thank you!!
Hit subscribe people!

[@jiejenn]

Glad my video helped and thank you for the support.

[@prianthagovender649]

@@jiejenn it is very difficult for people learning on their own. You are changing lives around the world. Keep up the good work!

[@timothyelliott7607]

Great vid!! Thank you

[@chandupandit5672]

thank you so much very helpful

[@sarazuhe1798]

Gracias!

[@arturocalderon4551]

Amazing, Thanks a lot!!

[@edgarcoto9870]

Thank you so much, you saved me.

[@ajayaj6483]

very helpful. Thanks a million times.

[@narendradwaram4432]

Thanks successfully added adventure work 2012

[@samtee7188]

This is amazing! thank you

[@Luckisto]

Thank you for the great video.

[@sushanthyadav9788]

Thanks a lot Jie Jenn

[@swevirgo]

THANK YOU VERY MUCH.

[@t0ll294]

For some reason my computer is running the .bak file as a video, if I got some help on this that would be amazing

[@Onyhn]

you are the man thanks

[@ruthruth9303]

Thanks bro! I was wondering why can't I see my file

[@helenangelafashion2043]

you are a great man. very helpful

[@crispomwangi6297]

Very very Helpful

[@eroek1]

Thank you dude, help me a lot.

[@ayophilip8997]

Thanks a lot!
Very useful!

[@jaspervalino8732]

amazing, thank you god.

[@yogeshgaikwad1767]

amazing work thanks

[@esotilin32z]

It helped bro thx a lot

[@vishalkhindri]

solved my problem.. Many thanks..

[@akanou77]

Thank you!

[@oladapoabdullahi]

Amazing explanation

[@mag00yt]

Nice video. But in my machine I need to give full access permission on folder to it works fine. Without this the SQL Express was returning permission error messages.
Thanks anyway.

[@nehakumari-zk8ou]

thank u so much...it worked for me....thanks you tube

[@ZeeshanAbbasiplanz]

thanks buddy!

[@breadsevenk]

I copied .bak file to the backup folder but I couldn't find this file when I want to restore the database. The folder was looking empty. What's the problem?

[@jiejenn]

Without looking at your screen, I can only take a guess it may be the wrong folder.