1. Type in the following URL into your browser's address bar
http://msftdbprodsamples.codeplex.com/
2. Click on the "Download" button on page
3. Click on the recommended download link
http://msftdbprodsamples.codeplex.com/
2. Click on the "Download" button on page
3. Click on the recommended download link
4. Unizp the file you just downloaded
5. Open the SQL Server Management Studio, then right click on "Databases" and then select "Restore Database"
6. Select "Device" under "Source"
7. Click on the "..." button, and the "Select" backup devices will appear, select "File" for "Backup media type"
8. Click on the "Add" button, and select the "AdventureWorks2014.bak" file, then click "OK"
8. Click "OK" on the "Select backup devices" screen
9. Click "OK" on "Restore Database" window
10. A message will pop up that says you have successfully restored the AdventureWorks2014 database
11. The "AdventureWorks2014" database is now added to your SQL Server instance
Thank you. All the other tutorials I read made this process very complicated. Yours was very easy to follow :)
ReplyDeleteYou are welcome, I am glad I can help :)
DeleteThanks! Crystal clear tutorial, very helpful for beginners like me :)
DeleteBrilliant! Thank you - I have hunted through all kinds of code and sites and this is the easiest, simplest and successful advice.
ReplyDeleteWell Done!
Thank u, ur giving this process in clear way
DeleteBest instructions I've seen! Thank you!
ReplyDeleteThank you very much for sharing this information. Installation successful after 1st try and three days of trying other means....
ReplyDeletewow, all the others tutorial were: copy the file there, run that script ... blah blah blah ..
ReplyDeletethanks
Thank you all for the comments. I am glad I can make the process a little bit less painful!
ReplyDeleteThanks a TON, most relevant and useful installation instructions I have ever come across
ReplyDeleteThis was very helpful and easy to follow. I did have to do one additional step:
ReplyDeleteAfter 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.
Oh! God bless you. I've giving up so many times trying to get this downloaded. Your tutorial is just 5 stars!
ReplyDeleteJASON 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.
ReplyDeleteSimple, 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!
Thank You So Much!
ReplyDeleteThank you so much! It is a very easy tutorial and I could install the database successfully.
ReplyDeleteI 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!
ReplyDeleteBefore 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.
ReplyDeleteThank 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!
ReplyDeleteThanks, excellent tutorial step by step and with pictures, very easy to follow, this is the best tutorial I've seen about this topic..
ReplyDeletebest tutorial - thanks
ReplyDeleteReally helped me, thanx
ReplyDeleteReally helped me, thanx
ReplyDeleteThank you!
ReplyDeleteWOW, other tutorials made that SO MUCH more complicated than you did!!!
ReplyDeleteGREAT JOB and THANKS!!!
thanks a lot techjunkie for heping out
ReplyDeleteAnother downside of having such a large number of components is that it expands the odds of something turning out badly.
ReplyDeletemicrosoft technical support
Thank you. That was amazingly simple compared to MSDN and every where else I've looked.
ReplyDeleteThank You Thank You Thank You :)
ReplyDeleteThank you!!! Thank you!!! Thank you!!!
ReplyDeleteI 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!!!!
Thank you so much. That is great
ReplyDeleteThanks for this awesome tutorial.
ReplyDeleteHow can I install Adventureworks 2014 "multidimensional"?
ReplyDeleteFUCKING THANK YOU FOR THIS!
ReplyDeletethanks a lot ... I was really helpful ...
ReplyDeleteThank you so much!
ReplyDeleteAfter the first wave of siege, the aggressor loses the advantage of surprise attack and leaves himself exposed to a counter attack.More info
ReplyDeleteDatabases 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
ReplyDeleteThanks! Really easy that way.
ReplyDeleteThank You So Much. It was very useful and easy to follow.
ReplyDeletethank you so much!!!
ReplyDeletethank you so much
ReplyDeleteThank's!!
ReplyDeleteThank 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.
ReplyDeleteawesome thank you
ReplyDeleteTotally awesome posting! Loads of valuable data and motivation, both of which we all need!Relay welcome your work. find out more
ReplyDeleteGreat Article it its really informative and innovative keep us posted with new updates. its was really valuable. thanks a lot. alternatives to google maps
ReplyDeleteDoes your game server provider have good support? How should I acquire the best support out from my server provider? What constitutes "good support"? ark server hosting
ReplyDeleteI love significantly your own post! I look at all post is great. I discovered your personal content using bing search. Discover my webpage is a great one as you.I work to create several content this post. Once more you can thank you and keep it create! Enjoy! https://serverbrowse.com/
ReplyDeleteI appreciate several from the Information which has been composed, and especially the remarks posted I will visit once more. https://serverbrowse.com/
ReplyDeleteExcellent post. I certainly appreciate this website.Keep writing.well here if you want to Overcome the issues of Avast antivirus.Pick the Best Assistance over our site to resolve your queries.Visit us :avast antivirus ondersteuning
ReplyDeleteI like your blog.You have done Excellent work. I appreciate.Here I want to inform all of you if you are looking for to resolve your Norton Antivirus problems,so you are in right place.we always available for your support.So whenever you need any help so just click on this link- norton Antivirus ondersteuningsnummer
ReplyDeleteI’m really impressed with your writing skills and also with the layout on your blog it's Very interesting to read.Now Here i would llike to share some information about HP Printer If you are facing any problem relate to your HP Printer's we wil resolve your queries at sam time.For any help please visit on our website:hp printer contact belgie
ReplyDeleteI am really enjoying your site.It’s simple, yet effective, thank you for this article.Now I have to share some information about How To Fix “mcafee Antivirus” problem. If you have any problem rearding Mcafee so click on this site:mcafee antivirus nummer belgie
ReplyDeleteSome people out there consider glitter on bright colors as heavenly combination. But choosing the right bright side for your nails is also a task. bulk craft glitter
ReplyDeleteIt proved to be Very helpful to me and I am sure to all the commentators here! שרת וירטואלי
ReplyDeleteI love the way you write and share your niche! Very interesting and different! Keep it coming! nemzetközi szállítmányozás Europa-Road Kft
ReplyDeleteNice post! This is a very nice blog that I will definitively come back to more times this year! Thanks for informative post. 리니지갤러리
ReplyDeleteI think this is an informative post and it is very useful and knowledgeable. therefore, I would like to thank you for the efforts you have made in writing this article. 熊猫VPN 安全
ReplyDeleteTo enhance network security and access control, proxy servers are used. When the network connects a huge number of computers, use of proxy servers becomes essential to have a centralized access to the internet.are there different levels for a vpn
ReplyDelete