Microsoft has launched Adventure Works 2014 database for its SQL Server 2014 version. Until 2012 Microsoft provided sample databases in format of mdf and ldf file downloads, a developer will download and attach the mdf and ldf file to install Adventure works 2012.It has changed the style completely with 2014, do watch the video to know about it. 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.
I am attempting to download AdventureWorks 2014. I downloaded from codeplex, which now exists in my WinZip as a .bak using Notepad as the default program. I unzipped the file, copied over to Program Files...SQLServer...Data. However, I believe the Notepad program will cause an issue when attempting to import the database. I was expecting to see AdventureWorks files ending in .mdf and .ldf. Would I need to change the default program for .bak or .zip? Also, what would I need to change it to to be able to successfully run the AdventureWorks import script.
Thanks!
AndrewC10
AndrewC10AndrewC10
1 Answer
The .bak file is a database backup file. Once you restore the database through SQL Server, you'll get your .mdf and .ldf files. Here's how to restore a database backup (your .bak file) for SQL Server 2014.
Ben RubinBen Rubin
Not the answer you're looking for? Browse other questions tagged sqladventureworks or ask your own question.