Adventure Works 2014 Sample Databases
Other Available Downloads
Will this work for sql server 2016?
on Jul 1, 2015 at 10:43 PM
Was waiting for it since May,
Adventure works 2014 has really met my expectations and found it helpful for my classes.Microsoft has made the installation process very simple than its 2012 version.
Here is a video link for its installation if you have any doubts.
on Sep 1, 2014 at 3:57 AM
I tried to install this on sql 2014 and it doesn't work. The bak file was made in some other version of sql and cannot be loaded by sql 2014. The install script was made in sql 2008 and uses data types ("date") that are not supported in sql 2014. Change the datatypes to DATETIME and the script will run. Also note that the default install location of SQL Server is different than what is specified in the script.
on Sep 15 at 8:40 PM
Where can i download a version for MS Access as *.accdb?
on Jan 13 at 11:54 AM
I Got Error;
Msg 3241, Level 16, State 0, Line 2
The media family on device 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Backup\AdventureWorks2014.bak' is incorrectly formed. SQL Server cannot process this media family.
Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.
on Dec 29, 2015 at 3:07 PM
For anyone with the message
"The media family on device 'blah' is incorrectly formed", the most likely reason is that you're trying to restore a SQL Server 2014 database backup onto an earlier version of SQL Server.
Whilst backups are forwardly compatible (which is a good thing), by the nature of development, there's no guarantee that data structures will be backwardly compatible with older versions.
Try finding a version of AW that's compatible with your version of SQL Server, or restore it on SQL Server 2014.
on Jul 15, 2015 at 10:01 AM
AdventureWorksDW database, SSAS Enterprise project, and Internet Sales Tabular project all work fine. I'm using these to test some Business Intelligence stuff so it would help to have the ETL processes for loading the DW database and maybe even some SSRS reports.
on Jun 9, 2015 at 2:56 PM
couldn't figure out how to install it - facing this error: The media family on device 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Backup\AdventureWorks2014.bak' is incorrectly formed
on May 28, 2015 at 10:36 AM
buck dasn't attach
on Apr 22, 2015 at 9:56 AM
It doesn't restore : after selecting the .bak file the info message states that there are no files selected.
on Apr 15, 2015 at 9:52 PM
All works around but I have an error:
The media family is incorrectly formed...
on Mar 24, 2015 at 2:47 PM
Junaith Haja's video was excellent. Be sure to download the release notes which contains the query script he references in his presentation.
on Jan 16, 2015 at 10:10 PM
Its Very Very Helpful ... Thanks..
on Sep 8, 2014 at 12:58 PM
Opera does not support ClickOnce X
To install this application, save it and then open it. Opening it directly from Opera will not work correctly.