|
|
Posted by Greg D. Moore \(Strider\) on 11/23/05 06:07
"maxzsim via SQLMonster.com" <u14644@uwe> wrote in message
news:57c4ce94c8400@uwe...
> 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)
Sounds decent.
>
> 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
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 SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-general/200511/1
Navigation:
[Reply to this message]
|