Einar,

From a Database Admin side of things:

Normally, the transaction log should not sit on the same disk as the database file, this is mainly for recovery reasons.

Generally, in my experience, a DBA would like all his database files in the same location and not scattered around in different places.

This really depends on how your going to distribute\rollout your product and whether you are just using MSDE\SSE or SQL Server 2005.

Regards

Jon


>I am installing a new instance of SSE through my app. My plan is to put the data (*.mdf) and the log (*.ldf) file in a sub directory of the application (C:\Program Files\myApp\Data) instead of in the "default" place (C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data).
>Is my proposal considered bad practice? Any reason not to do what I plan to do?
>The reason I want to do what I propose to do is to keep every thing that belongs to my app in the "same" place.
>Any thoughts are welcome.
>
>Thanks,
>Einar