Hi,

I have got a database (SQLSRV2000 Enterprise), and it has got one transactional log file.
if I set the Transactioal file size to 1500MB and auto growth on (no limit) over night the trans. log expands up to 2300MB
I have tried to set the Initial value the trans. file to 2500MB but next day the log file will be 1500 again!! in the database options the auto shink is on.
My understanding was that the auto shrink option, shrinks transactional log and also data(.mdf) file.

Is there any way to disable the shrinking option only on the transaction log not the data files(.mdf)

Thanks

S