[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 551
  • Last Modified:

sql server 2008 install Adventureworks

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?
0
chaverly
Asked:
chaverly
2 Solutions
 
HuaMinChenBusiness AnalystCommented:
You should be able to install that. Check this
http://msdn.microsoft.com/en-us/library/aa992075.aspx
0
 
Vikas GargBusiness Intelligence DeveloperCommented:
Hi,

the same question has been asked as in the below link

http://www.experts-exchange.com/Database/MS-SQL-Server/Q_28482885.html
0
 
chaverlyAuthor Commented:
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.
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
ValentinoVBI ConsultantCommented:
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.
0
 
Vikas GargBusiness Intelligence DeveloperCommented:
Hi,

Remove the log file since it will be created automatically and attach only MDF and that's it
0
 
chaverlyAuthor Commented:
Thank you. I could never have done this without you.
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now