Posted by maxzsim via SQLMonster.com on 11/23/05 07:28

tks , i have shrunk the database and will monitor how the log file grows

Greg D. Moore (Strider) wrote:
>> Hi ,
>>
>[quoted text clipped - 5 lines]
>> 2. Differential Backup - twice a day
>> 3. Txn log backup - 4 times a day (4hrs apart)
>
>Sounds decent.
>
>> Situation :
>> my Txn Log file is now 18GB ,i can see it's only taking up around 1.5 GB of
>[quoted text clipped - 5 lines]
>> grow to 18 GB unless between the txn log backup , there's alot of data coming
>> in that caused the txn log to grow but this is not the case
>
>Or at one point before you started your current backup schedule the log had
>expanded itself to 18 gig.
>
>I would suggest shrinking it and seeing what happens in a week.
>
>> kindly advise if my setup is wrong or what could have happened somwhere to
>> cause the log to grow so much
>>
>> tks & rdgs

--
Message posted via http://www.sqlmonster.com

[Back to original message]