Michael,
We have scheduled backup and is set to auto_shrink and remove inactive entries from transaction log but still the log file is huge. After one week it accumulates 2 gigabytes (it's now 8 gig from 6 gig last week) but the database file is only 600 MB. What's wrong here?
What is BOL anyway?
>Are you backing up or truncating the log file?
>
>Check the BOL.
>
>-Mike
>
>>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."