Post reply

attache database problem

  • March 22, 2011 at 5:01 am

    #248525

    Hi

    I am trying to attache a database mdf file, when i try and add the database i get the folder explorer but some of the folders are missing.

    My database is in my docs which is in users\username\my documents but i can see the my documents folder

    in fact i cant see any folders in the users\username folder

    do you know why?

    thankls in advance

  • March 22, 2011 at 5:09 am

    #1301791

    Most likely because the account that SQL is running under does not have permissions to that folder.

    Move the files (mdf and ldf) to the SQL data folder (whereever that was put at install time) and then you should be able to attach without problem.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 22, 2011 at 5:11 am

    #1301794

    Check the permissions. This happens when SQL Server service account doesn't have read permission to your folder.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply