AdventureWorks 2008 R2 Sample Databases

Question

I have downloaded 2008 R2 Adventure family databases EXCEPT Adventureworks2008R2 database , I can see Adventureworks, AdventureworksDW, AdventureworksDW2008R2 databases on object Explorer BUT DIDN'T see Adventureworks2008R2 database, have tried many times but failed.

Is anyone can hope me to download Adventureworks2008R2 database?

Thanks

David

 

Answer 1

Are you trying to install it on SQL08/R2 or is it on Denali? I experianced major issues getting it onto Denali, and in the end, I had to attach the database with rebuild log.

If you are on 08/R2, then make sure you have Full Text and FileStream enabled, as both of these are show stoppers!

Hope this helps. Let us know how you get on.

---

Peter Carter-Greenan http://sqlserverdownanddirty.blogspot.com/

Answer 2

Hi All,

i am also face same problem. even i try to attach AdventureWorks2008R2_Data.mdf it's also not working.

Please help on this.  i run setup AdventureWorks2008R2_SR1 but i didn't get Adventureworks2008R2  datbase.

i also check Full Text and FileStream  alerday enabled.

Answer 3

This may help you:

Some users have been unable to successfully install the AdventureWorks2008R2 OLTP database using the SR1 installer. We have added a version of the database without FILESTREAM as a single file that you can download and attach. To install
this version, go to AdventureWorks2008R2 without filestream

---

Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
MC ID: Microsoft Transcript

Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

Answer 4

Hello,

thanks Mr. Wharty. Even I faced the same issue. I will by the link and see that the issue is resolved

Answer 5

Did Mr. Wharty's answer help?

Thanks!

---

Ed Price (a.k.a User Ed), SQL Server Experience Program Manager (Blog, Twitter, Wiki)

Answer 6

We uploaded an AdventureWorks 2008 R2 OLTP database and script to CodePlex (http://msftdbprodsamples.codeplex.com/releases/view/59211). Or http://msftdbprodsamples.codeplex.com and click on the SQL Server 2008 R2 OLTP tile.

Hopefully, this version is easier to attach and use.

As long as you copy the database to C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\DATA, you should be able to attach the AdventureWorks2008R2_Data.mdf database. You will need to remove the transaction log reference.

Or you can run the setup script. Follow these steps to install the sample database from the script:

1. Download AdventureWorks 2008 R2 OLTP Script.zip (http://msftdbprodsamples.codeplex.com/releases/view/59211)
2. Copy the DDL script files to any path such {SQL Server Path}\Tools\Samples\AdventureWorks 2008 OLTP Script.
   
   Note The default SQL Server 2008 R2 path is C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\.
   
3. Open {SQL Server Path}\Tools\Samples\AdventureWorks 2008 OLTP\instawdb.sql in SQL Server Management Studio.
   
4. Update the script path variables.
   
5. If necessary, change the :setvar SqlSamplesDatabasePath variable to your SQL Server 2008 R2 path. The default path is C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA.
6. Change the :setvar SqlSamplesSourceDataPath variable to the path containing the .csv files.
7. Uncomment each :setvar variable.
8. On the Querymenu, click SQLCMD Mode.
9. On the Standardtoolbar, click the Executebutton to run the script.
   

Answer 7

This has really helped me! Thank you very much for posting this great solution! :)