Hi Jess,

I don't know, we haven't gotten around to the administrative side of the SQL server. I don't know what the conditions are for when the 'Shrinking' should occur.

Thanks,
Arriyel

>Thanks Arriyel!
>
>Would it be a wise decision if I'll set the the db option into auto_shrink?
>
>>Hi Jess,
>>
>>You might need to 'Pack' the data base if you do a lot of adds and deletes of records. You have to 'Shrink' the SQL database by right clicking on the database from within the SQL Enterprise Manager and select All Task; Shrink Database. You'll then need to go to Tools;SQL Query Analyzer do a 'checkpoint'. This should release all that data space used by the log file.
>>
>>HTH,
>>Arriyel
>>
>>>Why is it that our sqlserver log file seems too much bigger than the actual database file? And it grows rapidly. Log file is now 6GB versus 550MB database file. Need your advise ASAP.
>>>
>>>TIA