Failure to attach the AdventureWorks2008_Data database

Question

Hello there,

I recently bought a book on Microsoft SQL Server 2008 Database Development but I am failing to attach the AdventureWorks2008_data sample database that

comes with the book.  I am attaching this sample database under SQL SErver 2008 Enterprise  Evaluation edition on my vista machine. I have done this the right way by attaching the database using SSMS but I am wondering why I am getting this error message.


TITLE: Microsoft SQL Server Management Studio
------------------------------

Attach database failed for Server 'RONALDLEE-PC\RONNIE'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

FILESTREAM feature is disabled.
A file activation error occurred. The physical file name 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\Documents' may be incorrect. Diagnose and correct additional errors, and retry the operation.
Could not open new database 'AdventureWorks2008'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 5591)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.1600&EvtSrc=MSSQLServer&EvtID=5591&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Could someone out there bail me since I have spent to much time on this.

Thanks in advance.

Answer 1

Where is you Adventure works Mdf file and does this location 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\Documents' . exists ?

Now if it does that it is issue with you installation . FILESTREAM is not enabled by default. Look at this Bug for more details https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=349659&wa=wsignin1.0 and lets us know if you are able to resolve it

---

Ashwani Roy

My Blog

Please click the Mark as Answer button if a post solves your problem!

Answer 2

Hey there,

Actaully I have a AdventureWorks2008 folder in which I HAVE both th AdventureWorks2008_Data.mdf, AdventureWorks2008_Data.log and the Document folder that that has two files $FSLOG, 419cb40c-eaf5-4086-a60d-651ab009ceb0,  and a file named filestream.hdr. Do you have any idea about this.

Is there anything i have to do  to make this attachment work?

Answer 3

have you tried enabling filestream for the server?

EXEC sp_configure filestream_access_level, 2

RECONFIGURE

Answer 4

Yes, I have done that.

Still there is no success.

Answer 5

When I run the

EXEC

 

sp_configure filestream_access_level, 2

RECONFIGURE

I get the following:

Configuration option 'filestream access level' changed from 2 to 2. Run the RECONFIGURE statement to install.

What does this mean?

Answer 6

When you go to database properties, do you see under files: FileStreamDocuments?

It is pointing for me to: C:\Program Files\Microsoft SQL Server\MSSQL10.SQL2008\MSSQL\DATA

In this path, there is a Documents folder where I see the files you list.

Under filegroups there is DocumentFileStreamGroup with default checkmarked.

---

Kalman Toth, SQL Server 2008 Training, SSAS, SSIS, SSRS, BI: www.SQLUSA.com

Answer 7

Hello Toth,

Yes, Under C:\Program Files\Microsoft SQL Server\MSSQL10.SQL2008\MSSQL\DATA, there is a documents folder with those documentsfileStreamGroup.

Do you have idea on what to do?

I really stack.

Answer 8

Yes Toth,

These files are there.

Is there any procedure in SQL SERVER 2008 for attaching file stream enabled databases?

This is really confusing.

Answer 9

I don't have this database (AdventureWorks2008_Data) attached. It has failed to attach.

Answer 10

OK.

Let's go back to ground 0.

Download AdventureWorks2008 from the following link and follow setup instructions:

http://msftdbprodsamples.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=18407

Let us know if works.

---

Kalman Toth, SQL Server  Training, SSAS, SSIS, SSRS, BI: www.SQLUSA.com

Answer 11

Hello Toth,

This  works.

Thank you for coming to my rescue.

Regards,

Ronaldlee