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


Comments

  1. AnonymousJune 30, 2015 at 5:43 AM

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

    ReplyDelete
  2. AnonymousJuly 7, 2015 at 6: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
  3. AnonymousAugust 8, 2015 at 8:27 PM

    Best instructions I've seen! Thank you!

    ReplyDelete
  4. AnonymousJanuary 13, 2016 at 10:59 AM

    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
  5. UnknownJanuary 19, 2016 at 7: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
  6. AnonymousApril 5, 2016 at 9:44 AM

    Thank You So Much!

    ReplyDelete
  7. AnonymousJuly 1, 2016 at 8:25 PM

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

    ReplyDelete
  8. AnonymousJuly 4, 2016 at 10:34 PM

    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
  9. ElvisJuly 15, 2016 at 8: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

Post a Comment

Popular posts from this blog

SQL: GROUP BY And HAVING

Image
SQL GROUPING allows you to segregate data into groups so that you can work on it separately from the rest of the table records. Let's say you want to get the number of products in a category in the Northwind database Products table. You would write the following query: SELECT COUNT(*) NumberOfProductsByCategory FROM Products GROUP BY CategoryID The query above gives you the following results: The query gives you the number of products in each category, however it's not very useful. You don't really know what category the count is for in each record. You might want to try to change the query into something like this: SELECT CategoryID,COUNT(*) NumberOfProductsByCategory FROM Products GROUP BY CategoryID The above query is more useful the preceding one, however it only gives you the CategoryID number not the CategoryName in the Categories table. Being the perfectionist that you are you say to yourself, I can do better. "Yes, I can". I think that was a ca...
Read more

ASP.NET : Create an Empty Web Application Project in Visual Studio 2012

Image
The purpose of this blog is to show you the bare bones of ASP.NET.  Often times when you search for a tutorial on the web you see that the tutorials are way too complex or an overkill of what you are trying to do at that moment.  So the in this blog series I want to cut through all the fat and just show you how to get things done quickly. The best way to start an ASP.NET web application is to create an empty project.  In this tutorial I will show you how to create an empty web application project in Visual Studio 2012. You can download Visual Studio 2012 at http://www.microsoft.com/visualstudio/eng/downloads#d-2012-editions   you can get a 90 trial by registering with microsoft.com.  Another alternative is to download the free Visual Studio Express version at http://www.microsoft.com/visualstudio/eng/downloads#d-2012-express   Here are the steps to create an empty web application project in Visual Studio 2012 1. Open Visual Studio 2012 2. Click on "File", t...
Read more