Results 1 to 2 of 2
Thread: App_Data and SQL Server 2008
Mar 24, 2011, 15:49 #1
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?
Mar 24, 2011, 16:17 #2
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.