Failure to attach the AdventureWorks2008_Data database


All replies

  • 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 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!

    Friday, June 19, 2009 11:39 PM
  • 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?

    Saturday, June 20, 2009 1:04 AM
  • have you tried enabling filestream for the server?

    EXEC sp_configure filestream_access_level, 2

    Saturday, June 20, 2009 5:21 AM
  • Yes, I have done that.

    Still there is no success.
    Saturday, June 20, 2009 5:32 AM
  • When I run the



    sp_configure filestream_access_level, 2


    I get the following:

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

    What does this mean?

    Saturday, June 20, 2009 5:48 AM
  • 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:
    Saturday, June 20, 2009 5:54 AM
  • 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.
    Saturday, June 20, 2009 6:04 AM

  • Yes Toth,

    These files are there.

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

    This is really confusing.
    Saturday, June 20, 2009 6:12 AM

  • I don't have this database (AdventureWorks2008_Data) attached. It has failed to attach.
    Saturday, June 20, 2009 6:33 AM
  • OK.

    Let's go back to ground 0.

    Download AdventureWorks2008 from the following link and follow setup instructions:

    Let us know if works.
    Kalman Toth, SQL Server  Training, SSAS, SSIS, SSRS, BI:
    Saturday, June 20, 2009 6:48 AM
  • Hello Toth,

    This  works.

    Thank you for coming to my rescue.


    Saturday, June 20, 2009 7:23 AM