Adventure Works DW 2008 R2 Install Missing File

Question

I tried downloading the Adventure Works DW 2008 R2 database, but it's missing AdventureWorks2008R2_Log.idf.  I downloaded file from http://msftdbprodsamples.codeplex.com/releases/view/59211

Where can I get a working DB??  Thanks.

---

Evan Johnson

Answer 1

Hi Evan -

Believe you should be able to select the default log file (second row in the bottom "database details" pane) and remove it (click the bottom "Remove" button).  That should let SQL create a fresh log file when it attaches the mdf you have.

Hope that helps.

---

Brent Greenwood, MS, MCITP, CBIP
// Please mark correct answers and helpful posts //
http://brentgreenwood.blogspot.com