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

Hi ,

I am running SQL server 2000 sp3a and i have set up my database to be in
"Full Recovery" mode.

I am not able to understand if i have set anything wrong here :
1. Full database Backup - every weekend
2. Differential Backup - twice a day
3. Txn log backup - 4 times a day (4hrs apart)

Situation :
my Txn Log file is now 18GB ,i can see it's only taking up around 1.5 GB of
actual space used

Ques :
i thought after every full database backup on each weekend, the txn log
backup will clear up the txn log , if so i see no reason why the txn log can
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

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 SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-general/200511/1

[Back to original message]