Log File Backups

I am running regular maintenance jobs to back up database files nightly and
incremental log file backups every hour between 6am and 8pm. I notice that
the first log file backup seem to be extremely large 5gig, the database
backup that is created 7 hours prior to that is 4.1 gig. (SQL2000
standard - SP4) Can someone tell me if there is a better way to run these
job and what are the best parameters to include in a job to run this type of
job ' OR is it a normal thing for the first log file backup to be so
huge? Thanks,...WANNABE wrote:
> I am running regular maintenance jobs to back up database files nightly an
d
> incremental log file backups every hour between 6am and 8pm. I notice tha
t
> the first log file backup seem to be extremely large 5gig, the database
> backup that is created 7 hours prior to that is 4.1 gig. (SQL2000
> standard - SP4) Can someone tell me if there is a better way to run thes
e
> job and what are the best parameters to include in a job to run this type
of
> job ' OR is it a normal thing for the first log file backup to be so
> huge? Thanks,...
>
If there is alot of activity in the database during the 7 hours between
the full backup and the first log backup, then yes, it will be large.
What processes are run against that database overnight?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Yes, there are about 15 Stored Procs that run during the night to
recalculate
values, and adjustments.. But for the log backup to be larger then the db
backup
I was puzzled. Thanks
========================================
======
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:45534747.70107@.realsqlguy.com...
> WANNABE wrote:
> If there is alot of activity in the database during the 7 hours between
> the full backup and the first log backup, then yes, it will be large. What
> processes are run against that database overnight?
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||WANNABE wrote:
> Yes, there are about 15 Stored Procs that run during the night to
> recalculate
> values, and adjustments.. But for the log backup to be larger then the db
> backup
> I was puzzled. Thanks
The log file is basically a "journal", recording everything that happens
in the database. Those journal entries continue to accumulate until you
perform a log backup, at which point they are flushed out. You might
consider doing log backups around the clock, rather than just between
6am and 8pm...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Thank you, I will try log file backups around the clock
========================================
==
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:45534CF9.2040700@.realsqlguy.com...
> WANNABE wrote:
> The log file is basically a "journal", recording everything that happens
> in the database. Those journal entries continue to accumulate until you
> perform a log backup, at which point they are flushed out. You might
> consider doing log backups around the clock, rather than just between 6am
> and 8pm...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com