I am trying to figure out how to setup the options for the database logfile.  Our DDT package is getting deployed to an SQL 2005 Express Server, and everytime it gets deployed, the database_log.ldf is always set to initial of 2mb restricted growth to something like 2tb, I'm thinking this might be a bit high. 

Ideally I'm wanting to completely remove the logfile from the databse as it is using simple recovery model, the logfile isn't necessary, but I can't figure out how to tell Sql or the Database being deployed to ditch the ldf.  So now I am trying to figure out how to set the logfile to only be 5mb or something else small, and not to grow, basically to just sit there and shutup.

I've been looking through properties on the SqlExpress server Im working with, as well as adding the database_log file to the Filegroups in the DDT, but it never seems to have the same options I set when creating the File.

Any pointers?

Thanks,

Robin Giltner