The senario you use for SQL databases would only allow restore to the
point in time that is in the export file you are backing up.

Depending on your requirements, that may be sufficient.

However, many businesses would require a way of capturing activity that
occurred since the last backup of an export file.

We use SQL-BACKTRACK for our SYBASE and ORACLE backups, and the TDP for
the MS-SQL databases, though we are
looking at the TDP for Oracle.

>>> SBach AT MGE DOT COM 05/10/2005 9:10:13 AM >>>
We use the Domino TDP's to backup our Lotus Notes servers.  Backing up
the
Lotus Notes databases with the regular TSM Backup Client used too much
of
our resources.  The architecture is such that even using incrementals,
they were using up tapes faster than we could order them.  Each Lotus
Notes database averages well over 120 GB's, the reason we switched to
the
TDP's, which work specifically with the architecture of the Lotus
Notes
databases.

To backup many of our SQL databases though, the DB Administrator
creates a
flat file within the client server at a certain time each evening.
TSM
then incrementally backs up that flat file after it is created.


Shannon Bach
Madison Gas & Electric Co
Operations Analyst -Data Center Services
Information Management Systems
sbach AT mge DOT com






Lawrence Clark <Larry_Clark AT THRUWAY.STATE.NY DOT US>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
05/09/2005 12:57 PM
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Re: TSM, Lotus Notes and SQL BACKTRACK


Yes, you can do incremental backups on SQL Backups.
Most places would do weekly full, and daily incrementals, with
triggered logs backups as they fill.

>>> zarnocd AT NATIONWIDEPROVIDENT DOT COM 05/09/2005 1:30:24 PM >>>
Folks,

We have been eating up a LOT of tapes doing Notes and SQL backups
(Oracle).

Does anyone have any pointers concerning tape management and these?

BTW....We have a "permanent" retention policy on our Notes backups
dictated
by Corporate.

Also, I was told that we cannot do incrementals on either Notes or SQL
backups.

Thanks!

DaveZ