>If you were creating a database (MS SQL server database) on a customer's computer for your application, where would you put the data (.mdf) and log (.ldf) files?
>
>Would you put the files in the "default" MS SQL path (for that instance):
>C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\
>
>Or would you put the data in your application path something like this:
>C:\Program Files\My Company\My Application\Data\
>
Personally I wouldn't put data of any sort under C:\Program Files. It gets buried too deep, plus the whole concept of "Program Files" is lost. I prefer a structure like this:
C:\SQL Server Data
\Database1
database1.mdf
\Database2
database2.mdf
I also like keeping the mdf and ldf in the same folder.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only