Adventure Works DW 2008R2

• Jim1234

  SSC Eights!

  Points: 889

  More actions

  November 1, 2013 at 9:04 am

  #278665

  Hi,

  Please suggest where can I find Adventure Works DW 2008R2 database. I tried few downloads from codeplex but not able to attach the file.

  Note : Whenever the download is in Zip format. I unzip it and try to attach both mdf and ldf file, it throws an error "Unable to open physical file".

  Regards

  Jim

• Keith Tate

  SSCrazy Eights

  Points: 9938

  More actions

  November 1, 2013 at 9:14 am

  #1663447

  try this (make sure to change the InstanceName to your instance name:

  USE [master]

  GO

  EXEC sp_configure filestream_access_level, 2

  RECONFIGURE;

  go

  CREATE DATABASE [AdventureWorks2008] ON

  ( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.InstanceName\MSSQL\DATA\AdventureWorks2008_Data.mdf' ),

  ( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.InstanceName\MSSQL\DATA\AdventureWorks2008_Log.ldf' ),

  FILEGROUP [PRIMARY] CONTAINS FILESTREAM DEFAULT

  ( NAME = N'Documents', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.InstanceName\MSSQL\DATA\Documents' )

  FOR ATTACH

  GO

  Make sure you are not on your production system since you will be enabling filestream.

  ---

  
  Microsoft Certified Master - SQL Server 2008
  Follow me on twitter: @keith_tate

  Forum Etiquette: How to post data/code on a forum to get the best help[/url]