none
Failure to attach the AdventureWorks2008_Data database

Answers

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

    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
    RECONFIGURE

    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

    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?

    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: www.SQLUSA.com
    Saturday, June 20, 2009 5:54 AM
    Moderator
  • 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:

    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
    Saturday, June 20, 2009 6:48 AM
    Moderator
  • Hello Toth,

    This  works.

    Thank you for coming to my rescue.

    Regards,

    Ronaldlee
    Saturday, June 20, 2009 7:23 AM