Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Where would you put the data
Message
General information
Forum:
ASP.NET
Category:
ADO.NET
Environment versions
Environment:
C# 2.0
Database:
MS SQL Server
Miscellaneous
Thread ID:
01126461
Message ID:
01126472
Views:
17
>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
Map
View

Click here to load this message in the networking platform