In this example, I keep it in C:\databases. Click on SQL Server 2012 OLTP and you will be directed to the Downloads page for SQL Server 2012. AdventureWorks Multidimensional Models SQL Server 2012.zip (also download this multidimensional sample project while you are there for leaning SSAS/MDX, if you haven’t done so.) I suggest that you unzip all the files onto a one level folder on your C drive, instead of the Windows built-in Downloads folder or the Documents folder. Place the downloaded file (the MDF file) to your database folder.Mixing log files for the same mdf from a different source throws an exception. Also the log file that came with must be in the folder too. mdf file must be in the DATA folder of your particular database server folder. Download “Adventure Works” sample database from CodePlex at Adventure Works for SQL Server 2012 by select AdventureWorks2012 Data File. Worked in two seconds, just as you suggested Needless to add, but the Adventureworks.Step-by-step to install sample database Adventure Works
On this post, you will see step-by-step guide how to attach/install sample database Adventure Works on SQL Server 2012 Express using SQL Management Studio.