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...neral/200511/1

"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...neral/200511/1

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