SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Hybrid View

  1. #1
    SitePoint Zealot davejuk's Avatar
    Join Date
    Apr 2006
    Location
    UK
    Posts
    188
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Lightbulb App_Data and SQL Server 2008

    In the past I've used the App_Data directory for storing text files for e-mail templates and the occasional Access database.

    In SQL 2008, I've always put the .mdf in the SQL DATA directory. This works great but I thought it would be nice to have the entire application stored in one place.

    So I detached the database in the SQL Server Management Management Studio, moved the files to the applications App_Data folder, and went to reattach it. But it won't let me browse to C:\inetpub\vhosts\

    It just doesn't display any of its contents. I guess it's a permissions issue but I don't know what permissions to change. I log on to the database server using Windows authentication, and I'm logged into Windows as an Administrator.

    Should I not be using the App_Data directory in this way or something?

  2. #2
    Resident OCD goofball! bronze trophy Serenarules's Avatar
    Join Date
    Dec 2002
    Posts
    1,911
    Mentioned
    26 Post(s)
    Tagged
    0 Thread(s)
    It's been a while since I've seen this, but if I'm not mistaken, the mdf's internal name still reflects the old path and I don't recall now how to resolve it, but that should be enough info to search on google or msdn.

    [EDIT] Instructions on moving a database.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •