|
Home > Archive > Microsoft SQL Server forum > November 2005 > SQL backup - dun understand
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL backup - dun understand
|
|
| maxzsim via SQLMonster.com 2005-11-22, 8:23 pm |
| 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 webservertalk.com
http://www.webservertalk.com/Uwe/Fo...eneral/200511/1
| |
| Greg D. Moore \(Strider\) 2005-11-23, 7:23 am |
|
"maxzsim via webservertalk.com" <u14644@uwe> wrote in message
news:57c4ce94c8400@u
we...
> 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 webservertalk.com
> http://www.webservertalk.com/Uwe/Fo...eneral/200511/1
| |
| maxzsim via SQLMonster.com 2005-11-23, 7:23 am |
| tks , i have shrunk the database and will monitor how the log file grows
Greg D. Moore (Strider) wrote:[color=darkred
]
>[quoted text clipped - 5 lines]
>
>Sounds decent.
>
>[quoted text clipped - 5 lines]
>
>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.
>
--
Message posted via http://www.webservertalk.com
|
|
|
|
|