<div>
I downloaded the Adventureworks OLAP DB. The .mdf is currently in my Download folder. I enabled Filestream in the Configuration Manager. How do I run the database so I get an LDF file? &nbsp;I tried to attach the database, but it keeps giving me an error that an .ldf file does not exist.
</div>


I downloaded the Adventureworks OLAP DB. The .mdf is currently in my Download folder. I enabled Filestream in the Configuration Manager. How do I run the database so I get an LDF file?  I tried to attach the database, but it keeps giving me an error that an .ldf file does not exist.

<div>
You can attach it without the LDF, SQL Server will create it for you. &nbsp;After selecting the MDF in the <b>Attach Databases</b> screen just select the second line (the one with Log as File Type) and click the <b>Remove</b> button. &nbsp;Then you'll be able to attach the MDF.
</div>


You can attach it without the LDF, SQL Server will create it for you.  After selecting the MDF in the Attach Databases screen just select the second line (the one with Log as File Type) and click the Remove button.  Then you'll be able to attach the MDF.

<div>
Hi,<br />
<br />
Remove the log file since it will be created automatically and attach only MDF and that's it
</div>


Hi,

Remove the log file since it will be created automatically and attach only MDF and that's it

<div>
Thank you. I could never have done this without you.
</div>


Thank you. I could never have done this without you.

<div>
<div class="content wysiwyg-content">
I am trying to install Adventureworks sample database on SQL SERVER 2008 R2 Express. I went to the download site suggested and saw only Adventureworks 2014. I tried to download it, and am not finding it under &quot;C:\Program Files\Microsoft SQL Server\100\Tools\Samples\.<wbr /> What am I doing wrong?
</div>
</div>


I am trying to install Adventureworks sample database on SQL SERVER 2008 R2 Express. I went to the download site suggested and saw only Adventureworks 2014. I tried to download it, and am not finding it under "C:\Program Files\Microsoft SQL Server\100\Tools\Samples\. What am I doing wrong?

sql server 2008 install Adventureworks

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.