|
Home > Archive > MS SQL Server > November 2006 > Log File Backups
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]
|
|
| WANNABE 2006-11-09, 7:13 pm |
| 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,....
| |
| Tracy McKibben 2006-11-09, 7:13 pm |
| WANNABE wrote:
> 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,....
>
>
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 2006-11-09, 7:13 pm |
| 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
| |
| Tracy McKibben 2006-11-09, 7:13 pm |
| 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
| |
| WANNABE 2006-11-09, 7:14 pm |
| 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
|
|
|
|
|