Tech Junkie Blog - Real World Tutorials, Happy Coding!: SQL Server : Installing AdventureWorks Sample Databases from Microsoft

Wednesday, August 13, 2014

SQL Server : Installing AdventureWorks Sample Databases from Microsoft

1. Type in the following URL into your browser's address bar

     http://msftdbprodsamples.codeplex.com/

2.  Click on the "Download" button on page



AdventureWorks download button


3.  Click on the recommended download link

Adventure Works 2014 Sample Databases

4.  Unizp the file you just downloaded

5.  Open the SQL Server Management Studio, then right click on "Databases" and then select "Restore Database"
SQL Server Manager Studio


6.  Select "Device" under "Source"

SQL Server Device

7.  Click on the "..." button, and the "Select" backup devices will appear, select "File" for "Backup media type"

Select backup devices


8.  Click on the "Add" button, and select the "AdventureWorks2014.bak" file, then click "OK"

AdventureWorks2014.bak

8.  Click "OK" on the "Select backup devices" screen

Select backup devices

9.  Click "OK" on "Restore Database" window

Restore database

10.  A message will pop up that says you have successfully restored the AdventureWorks2014 database

Database 'AdventureWorks2014' restored successfully.

11.  The "AdventureWorks2014" database is now added to your SQL Server instance

AdventureWorks2014




Previous: SQL Server: The DELETE statement conflicted with the REFERENCE constraint
Next: SQL Server : Installing AdventureWorks Sample Databases from Microsoft

46 comments:

  1. AnonymousJune 30, 2015 at 8:43 AM

    Thank you. All the other tutorials I read made this process very complicated. Yours was very easy to follow :)

    ReplyDelete
    Replies
    1. Jason HuynhJune 30, 2015 at 6:35 PM

      You are welcome, I am glad I can help :)

      Delete
    2. AnonymousNovember 7, 2016 at 8:50 AM

      Thanks! Crystal clear tutorial, very helpful for beginners like me :)

      Delete
  2. AnonymousJuly 7, 2015 at 9:05 AM

    Brilliant! Thank you - I have hunted through all kinds of code and sites and this is the easiest, simplest and successful advice.
    Well Done!

    ReplyDelete
    Replies
    1. UnknownOctober 31, 2018 at 9:22 AM

      Thank u, ur giving this process in clear way

      Delete
  3. AnonymousAugust 8, 2015 at 11:27 PM

    Best instructions I've seen! Thank you!

    ReplyDelete
  4. UnknownAugust 12, 2015 at 9:54 AM

    Thank you very much for sharing this information. Installation successful after 1st try and three days of trying other means....

    ReplyDelete
  5. UnknownSeptember 10, 2015 at 12:09 PM

    wow, all the others tutorial were: copy the file there, run that script ... blah blah blah ..

    thanks

    ReplyDelete
  6. Jason HuynhSeptember 15, 2015 at 11:30 PM

    Thank you all for the comments. I am glad I can make the process a little bit less painful!

    ReplyDelete
  7. UnknownOctober 12, 2015 at 3:03 AM

    Thanks a TON, most relevant and useful installation instructions I have ever come across

    ReplyDelete
  8. AnonymousJanuary 13, 2016 at 1:59 PM

    This was very helpful and easy to follow. I did have to do one additional step:
    After step 4, I had to change the permissions on Adventureworks2014.bak file to be readable by everyone.
    Without this, there were no destination databases visible (the bottom part of step 9 was blank) and I couldn't proceed.

    ReplyDelete
  9. UnknownJanuary 19, 2016 at 10:30 AM

    Oh! God bless you. I've giving up so many times trying to get this downloaded. Your tutorial is just 5 stars!

    ReplyDelete
  10. UnknownMarch 18, 2016 at 4:41 PM

    JASON HUYNH for President 2016! (hope that is not taken as an insult considering...) I have determined that you are the most intelligent person on the internet!! I have searched for hours and days through endless inane and worthless posts to find this one. (I have run scripts that all failed and was about to type it all in manually.) Now I know how to install not only Adventure Works but any other .bak file I need.

    Simple, straight to the point and I installed the DB in literally seconds upon finding this. I wish you could teach all the other self-promoting [individuals] how to impart instructions. GREAT JOB!

    ReplyDelete
  11. AnonymousApril 5, 2016 at 12:44 PM

    Thank You So Much!

    ReplyDelete
  12. AnonymousJuly 1, 2016 at 11:25 PM

    Thank you so much! It is a very easy tutorial and I could install the database successfully.

    ReplyDelete
  13. AnonymousJuly 5, 2016 at 1:34 AM

    I share the same sentiment of those who posted before me. This is the best instruction that i have come across after hours of searching. No need to use scripts to restore and all that stuff. Really good and simple instruction to follow. Thank you very much!

    ReplyDelete
  14. ElvisJuly 15, 2016 at 11:25 PM

    Before I forget, did I say thank you? I don't think I can say thank you enough for your help. You're a real saviour, and let me just say it again and again and once again thank you so much Mr Huynh.

    ReplyDelete
  15. ElvisJuly 15, 2016 at 11:28 PM

    Thank you so much Mr Huynh for your help, I don't think I can say thank you enough to thank you. You're a saviour!

    ReplyDelete
  16. UnknownJuly 23, 2016 at 11:55 AM

    Thanks, excellent tutorial step by step and with pictures, very easy to follow, this is the best tutorial I've seen about this topic..

    ReplyDelete
  17. AnonymousAugust 2, 2016 at 7:53 AM

    best tutorial - thanks

    ReplyDelete
  18. VladoOctober 28, 2016 at 1:11 PM

    Really helped me, thanx

    ReplyDelete
  19. VladoOctober 28, 2016 at 1:11 PM

    Really helped me, thanx

    ReplyDelete
  20. UnknownNovember 28, 2016 at 5:09 PM

    Thank you!

    ReplyDelete
  21. UnknownJanuary 13, 2017 at 9:07 AM

    WOW, other tutorials made that SO MUCH more complicated than you did!!!

    GREAT JOB and THANKS!!!

    ReplyDelete
  22. hemu123February 15, 2017 at 7:42 AM

    thanks a lot techjunkie for heping out

    ReplyDelete
  23. ElizabethFebruary 20, 2017 at 7:26 AM

    Another downside of having such a large number of components is that it expands the odds of something turning out badly.
    microsoft technical support

    ReplyDelete
  24. AnonymousFebruary 20, 2017 at 4:45 PM

    Thank you. That was amazingly simple compared to MSDN and every where else I've looked.

    ReplyDelete
  25. FamilyFebruary 26, 2017 at 10:50 PM

    Thank You Thank You Thank You :)

    ReplyDelete
  26. AnonymousMarch 23, 2017 at 8:27 AM

    Thank you!!! Thank you!!! Thank you!!!
    I have no idea why everywhere else I looked made this so complicated.
    The clear and simple instructions complete with screen shots made it a total walk in the park.

    MUCH KUDOS. GREAT JOB!!!!

    ReplyDelete
  27. AnonymousMarch 28, 2017 at 5:02 AM

    Thank you so much. That is great

    ReplyDelete
  28. UnknownMay 11, 2017 at 12:38 AM

    Thanks for this awesome tutorial.

    ReplyDelete
  29. AnonymousMay 23, 2017 at 2:53 PM

    How can I install Adventureworks 2014 "multidimensional"?

    ReplyDelete
  30. TopherJuly 5, 2017 at 4:22 PM

    FUCKING THANK YOU FOR THIS!

    ReplyDelete
  31. tomymiahSeptember 16, 2017 at 2:22 AM

    thanks a lot ... I was really helpful ...

    ReplyDelete
  32. AnonymousSeptember 21, 2017 at 10:15 AM

    Thank you so much!

    ReplyDelete
  33. Aniqa RajputSeptember 28, 2017 at 3:55 AM

    After the first wave of siege, the aggressor loses the advantage of surprise attack and leaves himself exposed to a counter attack.More info

    ReplyDelete
  34. Steve ROctober 7, 2017 at 4:43 AM

    Databases can be so useful, nowadays even small organizations use them. Everywhere you look, there is a database: mailing lists, customer profiles, organizing a wedding, routing toll free telephone calls all over the country... Some are small and simple. Some are immense and complex.excel reporting dashboard

    ReplyDelete
  35. AnonymousOctober 31, 2017 at 12:40 PM

    Thanks! Really easy that way.

    ReplyDelete
  36. AnonymousJanuary 30, 2018 at 11:03 PM

    Thank You So Much. It was very useful and easy to follow.

    ReplyDelete
  37. UnknownFebruary 24, 2018 at 10:11 AM

    thank you so much!!!

    ReplyDelete
  38. AnonymousMarch 2, 2018 at 3:24 PM

    thank you so much

    ReplyDelete
  39. AnonymousApril 1, 2018 at 2:09 PM

    Thank's!!

    ReplyDelete
  40. UnknownJune 24, 2018 at 2:14 AM

    Thank you so much! After struggling for several days to get the correct SQL Express Server installed and configured, this was a breath of fresh air to have this work so quickly and efficiently. I simply selected the .BAK for AdventureLT2014 and it was visible. I worked with Azure until the 30-day expired and had to find a way to setup the database and server locally. After finding out that SQL Server 2017 could not be used for this purpose, the frustration began to uninstall both the SQL Server and SSMS and trial and error of finding which SQL Server would work on Windows 7 because SQL Server 2016 would not install. Hopefully, no one else will have to go through this painful experience. Best Wishes.

    ReplyDelete
  41. UnknownJuly 24, 2018 at 8:34 AM

    awesome thank you

    ReplyDelete
  42. Jims lindaSeptember 23, 2018 at 1:06 PM

    Totally awesome posting! Loads of valuable data and motivation, both of which we all need!Relay welcome your work. find out more

    ReplyDelete
  43. Zack SmithJanuary 13, 2020 at 1:33 PM

    Great Article it its really informative and innovative keep us posted with new updates. its was really valuable. thanks a lot. alternatives to google maps

    ReplyDelete

Subscribe to: Post Comments (Atom)

Search This Blog