Hi,
Let me about my app & the configuration of the server.My app is a desktop based application which i have installed over no of locations (as clients) & my DB resides on a IBM Server X3650 (Intel Xeon Processor @ 2.66 GHz) with RAM - 6 GB & 6 Hard Disks Configured in this way (1 hard disk (130 GB) - For OS & SQL Server , 2 Hard Disks (140 GB Each) with Raid 1 - In this I have my App and the LDF files & SQL Sercers tempdb, 3 Hard Disks (140 GB Each) with Raid 5 - In this I have the MDF Files). SQL Server i am using is 2005 Enterprise Edition with SP3.

As you assumed I have enabled the Log file Autogrowth. Currently I have kept SIMPLE RECOVERY (can u tell me what will be advantage in having FULL RECOVERY), turned off the AutoShrink property , set the initial size of my log file to 42 MB.

My app needs more no of reads than the writes (but not very little writes). Also in the past few days i notice that after i take the backup of my db my log file size gets shrinked to 42 MB even though it has grown through out the day.

I am not a DB expert just a learner.

Also want to know that more the log file size will there be better performance ??