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. >>> [EMAIL PROTECTED] 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 [EMAIL PROTECTED] Lawrence Clark <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[email protected]> 05/09/2005 12:57 PM Please respond to "ADSM: Dist Stor Manager" To: [email protected] 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. >>> [EMAIL PROTECTED] 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
