attaching adventureworks2008 on full version of sql server

attaching adventureworks2008 on full version of sql server: For anybody that bought the SQL Server 2008 Self-Paced Training book for 70-433, if you are running a full version of SQL Server 2008 rather than the express edition, you will have problems attaching the AdventureWorks2008 database (file activation error). The trick is to use a SQL command, like so:

USE [master]
GO
CREATE DATABASE [AdventureWorks2008] ON
( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQL2008\MSSQL\DATA\AdventureWorks2008_Data.mdf' ),
( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQL2008\MSSQL\DATA\AdventureWorks2008_Log.ldf' ),
FILEGROUP Documents CONTAINS FILESTREAM (NAME = Documents, FILENAME=N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQL2008\MSSQL\DATA\Documents')
FOR ATTACH
GO; posted on Tuesday, June 09, 2009 12:39 PM Print

Comments

# 70-433 book PDF?: Jorge Pedraza; 6/9/2009 5:31 PM; hi dear.
please can provide the pdf book.

can help me?

greetings

# re: attaching adventureworks2008 on full version of sql server: Mt; 8/18/2009 12:21 AM; not working, "Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "C:\Program Files\Microsoft SQL Server\MSSQL10.SQL2008\MSSQL\DATA\AdventureWorks2008_Data.mdf" failed with the operating system error 3(failed to retrieve text for this error. Reason: 1815)."
What's the problem?

# re: attaching adventureworks2008 on full version of sql server: Rov; 11/4/2009 4:42 AM; I racked my brain for 2 days. Searched numerous blogs on the net for a solution to attach AdventureWorks2008 database but to no vail. Your script did the trick. Thanks heaps for sharing.

Post Comment

Enter the code shown above

Archives

Post Categories

The Wrecking Bawl