AdventureWorks2008 & AdventureWorksSW2008 - msi files

Question

I cannot locate AdventureWorks2008.msi and AdventureWorksDW2008.msi files. Can someone send me a link where the files are located? I have already downloaded the Sample Databases, however, they do not have these files.

PLEASE HELP!!!!1

Answer 1

You will not see .msi files after downloading.  An MSI file is simply an installation mechanism and is not included in the download.  What you should see in the folder that you downloaded to are files such as "AdventureWorks2008_Data.mdf and AdventureWorks2008_Log.ldf.  In addition, you should see the AdventureWorks2008 and AdventureWorksDW2008 databases from the Object Explorer in SQL Server Management Studio.

If you cannot see the databases in Object Explorer or find the .mdf and .ldf files in a folder, then the download was unsuccessful.  I recommend that you run the installation process again from here: http://msftdbprodsamples.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=37109  This link takes you to a revised installation process (an .exe) that is much more reliable and will tell you if you are missing any prerequisites that may cause the installation to fail.  Please read the  Database Prerequisites first. It will save you time and frustration.

Regards,
Gail

---

Gail Erickson [MS] This posting is provided "AS IS" with no warranties, and confers no rights

Answer 2

Gail - Thank you for your response.  I ran the above routine and it was all successfull. However, when I wrote the Query - below & the message that I got after executing the Query.  I am not an expert on SQL and am learing SQL by using MS SQL 2008 Step-By-Step book and following the instructions as they are listed in it. I would appreciate your guidance.

Thanks
Syed

EXEC

 

sp_configure 'filestream_access_level',2;

GO

RESTORE

 

DATABASE AdventureWorks FROM DISK='C:\program files\Microsoft SQL Server\100\Tools\Samples\Adventureworks2008.bak' WITH RECOVERY;

GO

RESTORE

 

DATABASE AdventureWorks FROM DISK='C:\program files\Microsoft SQL Server\100\Tools\Samples\AdventureworksDW2008.bak' WITH RECOVERY;

GO

I get the below message.

Configuration option 'filestream access level' changed from 2 to 2. Run the RECONFIGURE statement to install.

Msg 3201, Level 16, State 2, Line 1

Cannot open backup device 'C:\program files\Microsoft SQL Server\100\Tools\Samples\Adventureworks2008.bak'. Operating system error 2(The system cannot find the file specified.).

Msg 3013, Level 16, State 1, Line 1

RESTORE DATABASE is terminating abnormally.

Msg 3201, Level 16, State 2, Line 1

Cannot open backup device 'C:\program files\Microsoft SQL Server\100\Tools\Samples\AdventureworksDW2008.bak'. Operating system error 2(The system cannot find the file specified.).

Msg 3013, Level 16, State 1, Line 1

RESTORE DATABASE is terminating abnormally.

Answer 3

Ah, that's helpful information.  Evidently that particular book was based on a pre-release version of AdventureWorks2008 in which we included a .bak file.  Due to some difficulties associated with that method, the .bak file was removed from the final release of the AdventureWorks2008 samples. 

For now, you need to forget about the installation steps in that book and use the link I supplied above.  When you run the .exe from that link, it will download the necessary files and create the databases for you.  There will be no need to restore from backup.

Hope that helps,
Gail

---

Gail Erickson [MS] This posting is provided "AS IS" with no warranties, and confers no rights

Answer 4

Hello,

I am using the same book and am at the same part as Syed, but I can't seem to find these downloads on the Codeplex website.  Are these downloads still available? If not, can you provide some suggestion on how to proceed?

Answer 5

hello Scott

which version do you need ?

the one for SQL Server 2008 or the one for SQL Server 2008 R2 ?

please read the following sticky thread about AdventureWorks sample db:

http://social.msdn.microsoft.com/Forums/en-US/sqlserversamples/thread/9dd84ee1-8a97-49a1-8f4b-ab0fad4e0d9d

---

Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Answer 6

Hi Daniel,

Thanks for the reply and the sticky.  I need the version for SQL Server 2008.

Thanks,

Scott

---

Scott Olander

Answer 7

hi Scott

in this case look at the last posting from Derrick in the above link which contains a link to the script for installing AdventureWorks on SQL Server 2008.

http://msftdbprodsamples.codeplex.com/releases/view/89502

---

Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.