this as a
supplement to DB backups to tape (DR for TSM, Fast DB Restore, yadda yadda
yadda).
From: Matt Simpson [EMAIL PROTECTED]
Reply-To: ADSM: Dist Stor Manager [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: Database backup strategy?
Date: Thu, 13 Mar 2003 11:43:06 -0500
At 11:25 AM -0500 3/13/03
I'm curious about the type and frequency of database backups that
people do. I've inherited a TSM environment set up by sombeody else
and I'm trying to make sense out of it.
The original setup did two backups every day, a full and a snapshot.
The full stayed onsite and the snapshot went offsite.
Matt,
In my shop, we do full backups of the TSM database. That is
because the TSM database will fit on one tape. When the TSM
database span across two tapes, then we will be thinking about
doing incremental backup of the database. Keep in mind that you
can only do so many incremental backup of
At 11:25 AM -0500 3/13/03, Sias Dealy wrote:
If TSM was doing a full backup twice a day. I would suspect,
the reason on why two backups are done is to keep the recovery
log from over committing. That is if TSM is in rollforward mode.
Since both the backups are scheduled in the morning, I don't
and incremental backup series.
Zlatko Krastev
IT Consultant
Sias Dealy [EMAIL PROTECTED]
Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED]
13.03.2003 18:25
Please respond to hnre
To: [EMAIL PROTECTED]
cc:
Subject:Re: Database backup strategy?
Matt,
In my
[EMAIL PROTECTED]
13.03.2003 18:25
Please respond to hnre
To: [EMAIL PROTECTED]
cc:
Subject:Re: Database backup strategy?
Matt,
In my shop, we do full backups of the TSM database. That is
because the TSM database will fit on one tape. When the TSM
I do a full DB backup on Saturday morning after daily processing, then an
incremental everyday after until the following Saturday. If we are doing
an upgrade, major change, etc., with our system I will then do a full
volume backup before and after but that is the only time I variate from the
Matt,
We do a full backup once a week and incrementals every other day. Our full
backups take about 2 hours and the incrementals only take an hour or less
depending on the activity for that day. If you don't save any time by
doing the incrementals then you are better off doing fulls. It takes
We backup the data base once a day and send it offsite. We also run the
log in rollforward mode. This means if we still have the log, we can
restore the data base and recover to the point of failure. Recovering
without the log would obviously mean we only recovered to the point of
the db