AdventureWorks2008R2 without filestream

Rating:        Based on 44 ratings
Reviewed:  38 reviews
Downloads: 439590
Released: Jan 14, 2011
Updated: Jan 17, 2013 by mlynd
Dev status: Stable Help Icon

Recommended Download

Application AdventureWorks2008R2 Data File
application, 200640K, uploaded Apr 3, 2012 - 227749 downloads

Other Available Downloads

Source Code AdventureWorksDW2008R2 Data File
source code, 74944K, uploaded Apr 3, 2012 - 63731 downloads
Application AdventureWorks 2008R2 OLTP Script
application, 20074K, uploaded Jan 15, 2013 - 32884 downloads
Source Code AdventureWorks 2008R2 DW Script
source code, 9018K, uploaded Jan 15, 2013 - 33516 downloads
Application AdventureWorks 2008R2 LT Script
application, 916K, uploaded Jan 15, 2013 - 13409 downloads
Application AdventureWorks2008R2-Full Database
application, 36075K, uploaded Jun 27, 2012 - 34278 downloads
Application AdventureWorksDW2008R2 cube for SSAS 2008 R2
application, 36972K, uploaded Jul 20, 2012 - 24092 downloads
Application AdventureWorks 2008R2 LT Data File
application, 5312K, uploaded Aug 12, 2012 - 9931 downloads

Release Notes

Update as of 7/19/2012: There is a new backup of the AdventureWorksDW2008R2 cube for SSAS 2008 R2 available: AdventureWorksDW2008R2 cube for SSAS 2008 R2.

Update as of 4/2/2012

How to install the AdventureWorks2008R2 OLTP database

Note: After attaching AdventureWorks2008R2_Data.mdf, you will need to remove the ldf log file listed below the mdf file.

This release is dedicated to the Adventure Works sample databases and related scripts that ship for Microsoft SQL Server 2008 R2. This release uses the AdventureWorks2008R2 and AdventureWorksDW2008R2 sample databases (added on 3/30/2012), without filestream. These databases cannot be installed on any version of SQL Server other than SQL Server 2008 R2.

You can also download a script and .csv files (added on 3/30/2012) to install the databases from script.
For details on how to install the AdventureWorks20008R2 OLTP database, the AdventureWorks20008R2 DW database, or to install either of these from script, see the SQL Server Samples Readme.

Reviews for this release

After the files are downloaded, go to properties. You may need to "unblock" the file. Also check security and make sure your user is given full control. When you go to attach the database, if it says the log file doesn't exist, remove the log file and just attach the mdf file. If the log file does not have an error message, you should be able to attach it without issue.
by intrkm on Jan 27 at 2:25 PM
Attach database failed for Server 'SL-1SDPC016'. (Microsoft.SqlServer.Smo) For help, click:
by ibumpsetspike08 on Aug 12, 2013 at 4:10 PM
To attach a database I had to: 1. change permissions to include my windows account (Full Access); 2. right click databases, select the file in the pop up that opened; 3. delete the log file in the pop-up; 4. click ok
by rscant01 on Jul 18, 2013 at 6:03 AM
I succesfully attached using: 1) Open SQL Management Studio 2) Right-click "Databases", select "Attach" 3) Select Adventure Works DW MDF file but remove the LOG file, click OK. The log file will be recreated after the database is attached.
by pritinp on Apr 29, 2013 at 3:29 PM
Hi, How to attach AdventureWorksDW2008R2 Data File: 1. After download copy the mdf file to a known location (I copied to E:\MSSQL10_50.MSSQLSERVER2008\MSSQL\DATA\AdventureWorksDW2008R2_Data.mdf) 2. Use the following script: use [master] EXEC sp_attach_single_file_db @dbname='AdventureWorksDW2008R2', @physname=N'E:\MSSQL10_50.MSSQLSERVER2008\MSSQL\DATA\AdventureWorksDW2008R2_Data.mdf' GO Amir
by amirhh2000 on Apr 9, 2013 at 7:29 AM
1) Downloaded AdventureWorks2008R2_Data and moved it to the DATA Folder 2) USE master; GO sp_detach_db [AdventureWorks2008R2] ; GO CREATE DATABASE [AdventureWorks2008R2] ON (FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\AdventureWorks2008R2_Data.mdf') FOR ATTACH ; GO
by romikukreja on Mar 7, 2013 at 3:07 PM
bu nasıl bir iş ya nasıl ındırıcez
by EksenGrup on Feb 9, 2013 at 4:29 PM
I am trying to have Adventure works database in my instance which I was unable to do even after my second visit because of there is no clarity and lack of simple steps to do the same. Kind of frustrated where these basics are getting ignored with little attention for laying foundation to get inducted into main stream ( A new users sorely missing this).
by ramac on Dec 29, 2012 at 1:10 PM
I can't download the AdventureWorksDW2012_Data ! The dawnload stops at 2Kb of file!
by zero51 on Dec 17, 2012 at 9:24 AM
Quick and easy. to attach the mdf use..... USE [master] GO CREATE DATABASE [AdventureWorks2008R2] ON ( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.SQL01\MSSQL\DATA\AdventureWorks2008R2_Data.mdf' ) FOR ATTACH_REBUILD_LOG GO -- change the leafname and/or filename as appropriate
by nickmcnair on Dec 6, 2012 at 12:26 PM
I am not able to attach the mdf file.. can someone help me please My error msg "TITLE: Microsoft SQL Server Management Studio ------------------------------ Attach database failed for Server 'RAKESH-PC\SQLSERVER2008'. (Microsoft.SqlServer.Smo) For help, click:
by rakesh309 on Nov 19, 2012 at 2:37 PM
I don't understand why you put a data file out there (Adventureworks2008R2.mdb) if you can't simply attach to it. I attach to it and get some kind of log error. What is that about?
by haydnguy on Aug 24, 2012 at 5:04 AM
Instructions were not clear enough for a beginner but the user comments helped me to get it installed properly. Thanks for everyones comments they helped. Thank you Microsoft for offering this database for us to use and practice on.
by MitchellPearson on Aug 12, 2012 at 11:04 PM
I can't beleive how difficult getting a sample database setup. I give up, i'll just use Oracle to learn SQL.
by tmack8080 on Aug 9, 2012 at 6:57 PM
The AdventureWorksLT2008R2 Database architecture is not supported by Entity Framework. Do not waste your time. Microsoft needs to prove that the new functionalities inherent in SQL Server 2008 Rx and SQL Server 2012 are fully supported by their own frameworks and/or platforms.
by parkstech on Jul 24, 2012 at 5:24 PM
Thanx karll . removing the log file worked .
by priya25 on Jul 6, 2012 at 8:34 AM
Right click on data file and click unprotect Then also add special permission or make sure you have full access to the file (which was causing my issue while attaching) And attach in command line, it s easier EXEC sp_attach_db @dbname = N'MyDB', @filename1 = N'd:\SQL\AdventureWorks2008R2_Data.mdf' it will complain about ldf but will create one
by underscoreit on Jun 12, 2012 at 10:58 PM
If you are trying to attach db the file, remove LDF from below section and try. it works
by AshishAgrawalla on Jun 1, 2012 at 12:43 PM
Thanks Karll. Removing the log worked for me.
by PingPing on May 14, 2012 at 7:36 PM
Try this: Remove the log file from the Database details list, after then you can attach the database.
by Karll on May 10, 2012 at 7:49 AM
I agree that this sucks - There is no log file so I could not install the database. Then - tried to use a Script to CREATE AdventureWorks2008R2 from the Downloaded Excel files containing the Tables Data - but the attached script would not run. Got the Variables declared but then the Run Time Substitution didn't appear to work - even with all the variables now redefined to include the "@" :-(
by CaptainMorgan on May 3, 2012 at 3:26 PM
There is no log file so I could not install the database.
by bkaporch on Apr 17, 2012 at 2:20 PM
There must be 2 conditions completed to install these database 1. Full-text Filter Daemon Launcher installed and running 2. Filestream future configured: (to enable filestream type this command) EXEC sp_configure 'filestream_access_level', 2; GO 3. Do the 4 point from the instruction on this page.
by lukaszkkk on Mar 4, 2012 at 5:57 PM
三界功绩2012年2月15日 15:24:42
by lin050620 on Feb 15, 2012 at 6:24 AM
Doesn't work with the Developer version (10.3.5500), which errors out identifying the developer version as a server which "supports version 655 and earlier". DeepaRaveendran had the same issue last year.
by bearle on Jan 23, 2012 at 5:45 PM
How do you restore this MDF file in SQL 2008? I'm using SQL 2008 R2 x64 Standard edition on a Windows 2008 R2 x64. Seems like this should work, but I just get this error: The media family on device 'C:\Users\sharepointadmin\Desktop\AdventureWorks2008R2_Data.mdf' is incorrectly formed. SQL Server cannot process this media family. RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Serve
by steve02a on Jan 7, 2012 at 8:36 AM
Great Work. Initially I was getting error because I put the file in D drive. Then I put the mdf in C:\Program Files\Microsoft SQL Server\MSSQL10_50.KJ\MSSQL\DATA and it was successful
by bhaskar_joardar on Sep 16, 2011 at 12:15 PM
I don't see a mention anywhere that this database has a case sensitive collation!!!
by MartinBell on Aug 24, 2011 at 9:11 PM
In order for this to work for me as soon as the file was finished downloading I right-clicked the file and selected "Properties". Then I selected the "Unblock" button within the properties window. Then and only then was I able to attach it to my SQL Server 2008 R2 instance.
by TimFromDallas on Jun 29, 2011 at 10:02 PM
The AdventureWorks2008R2 database installed fine, is there a place where I can get the AdventureWorksDW2008R2 database without Filestream as well? I could not find it on the site. I'm using the 32 bit version of SQL Server 2008 R2 on a 64 bit Windows 7 machine so I cannot enable FILESTREAM
by BrentKnorr on Jun 28, 2011 at 2:20 AM
Works like charm. I used the SQL Server UI version to attach a database.
by sudhirke on Jun 9, 2011 at 5:05 PM
This is the simplest AdventureWorks download yet! Thanks, Gail!
by nealgraves on May 18, 2011 at 4:55 PM
Works like a charm, but then again I'm using SQL Server 2008R2 x64 Enterprise Edition. :)
by tranpeter on Apr 22, 2011 at 5:23 AM
The database 'AdventureWorks2008R2' cannot be opened because it is version 661. This server supports version 655 and earlier. A downgrade path is not supported. I get the above error when i try to attach this AdventureWorks2008R2_Data.mdf Please provide me a solution
by DeepaRaveendran on Apr 19, 2011 at 8:43 PM
NOTE: Make sure you have FILESTREAM Enabled within your SQL Server 2008 instance. If you do not, this extraction and setup process will not create the databases in your SQL Server Object Explorer. If you do not know how to enable FILESTREAM for your server, hit F1 (to open Help), and type in "Enable FILESTREAM". - I'd put it here, but I am limited to the number of characters.
by PPicklesimer on Mar 1, 2011 at 9:15 PM
Hmmm...the command fails: Msg 5120, Level 16, State 101, Line 1 Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA". Operating system error 5: "5(Access is denied.)". Seems like SQL server should be allowed to access its own files, but just to make sure, I tried to give it full control. Windows rejects this despite the fact that I'm an admin?
by brg5002 on Feb 4, 2011 at 9:33 PM
Hi Carl. Sorry that you're having problems. It may be that the file did not download cleanly. Download the file again and then try to attach. Also, if you have multiple versions of SQL Server installed, make sure you're connected to the 2008R2 instance. Regards, Gail Erickson SQL Server Documentation
by Gaile on Jan 24, 2011 at 3:49 AM
This is not working. I have Sql Server Express R2 (10.50.1600.1) on Windows 7. Full Text is running This is what I get. Either with the script or through the UI to attach the DB. The header for file 'C:\Program Files (x86)\...\AdventureWorks2008R2_Data.mdf' is not a valid database file header. The FILE SIZE property is incorrect. What am I missing?
by CarlCoutureYahoo on Jan 18, 2011 at 2:44 AM