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
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."
