A full database MDF data file of AdventureWorks2012CS. A SQL Server script and.csv data files for installing AdventureWorks2012CS. AdventureWorksLT2012 (OLTP, lightweight version) adventure-works-2012-oltp-lt-data-file.mdf. A full database MDF data file of AdventureWorksLT2012. How to install adventure works 2014 sample databases 1. Readme for Adventure Works 2014 Sample Databases Install the Adventure Works 2014 OLTP database from a script The Adventure Works database can be created by running the instawdb.sql DDL script contained in the Adventure Works 2014 OLTP Script.zip file.
This release contains the full database files, scripts, and projects for AdventureWorks2012. They are for use with SQL Server 2012 and later versions. These samples are migrated from Codeplex.
For the multidimensional and tabular models, see AdventureWorks for Analysis services.
A full database MDF data file of AdventureWorks2012_CS.
A SQL Server script and .csv data files for installing AdventureWorks2012_CS.
AdventureWorksLT2012 (OLTP, lightweight version)
A full database MDF data file of AdventureWorksLT2012. T
A SQL Server script and .csv data files for installing AdventureWorksLT2012.
AdventureWorksDW2012 (data warehouse) downloads
A full database MDF data file of AdventureWorksDW2012.
Images for AdventureWorksDW2012.
I have been trying to add adventure works database to my SQL server 2012..I tried to attach the database using SQL Server Management Studio as follows: I Right Clicked on Databases > Attach and clicked Add... > selected the AdventureWorks2012_Data file. and then I Selected the log file and removed the log file by clicking on the Remove button then clicked OK but I still get an error that the header file is not a valid database header file and the FILESIZE property is incorrect ......please help me
AkhilAkhil
1 Answer
As Martin suggested, it may be that the file you downloaded is incorrect. You should download a new copy from here (I wouldn't get it anywhere else):
Once you do, don't use the UI for this. Make sure you copy the .mdf file to your instance's data folder. Then run this code in a query window:
You will get this 'error' message:
File activation failure. The physical file name 'drive:pathAdventureWorks2012_Log.ldf' may be incorrect.
This is just SQL Server telling you that it didn't find the log file; it should still create one for you unless you have other issues (permission denied, lack of space, the same name file already exists, etc).
Aaron BertrandAaron Bertrand
Not the answer you're looking for? Browse other questions tagged sqlsql-server-2012-expressadventureworks or ask your own question.