That's wonderful ! Many thanks for all your help with this.
All the best Farren Minns Solaris System Admin / Oracle DBA IT - Hosting Services John Wiley & Sons, Ltd. |-----------------------------+-------------------------------------------| | Del Hoobler | | | <[EMAIL PROTECTED]> | | | Sent by: "ADSM: Dist Stor | To| | Manager" | [EMAIL PROTECTED]| | <ADSM-L@VM.MARIST.EDU> | DU | | | cc| | 03/11/2005 14:14 | | | | Subject| | Please respond to | Re: [ADSM-L] Re | | "ADSM: Dist Stor | TDP for Lotus | | Manager" | Domino (again) | | <ADSM-L@VM.MARIST.EDU> | | | | | | | | | | | | | | | | | |-----------------------------+-------------------------------------------| Farren, You should be happy. Things are working exactly as they should. That is one of the large benefits that you get by using transaction logging. Since every change to a logged database is captured in the transaction log, you are backing up only the necessary changes when you back up the transaction logs. The DBIIDs shouldn't normally change during the week, unless you run maintenance activity (like compaction)... which most customers perform on the weekends just before their full (selective) backups. Thanks, Del ---------------------------------------------------- "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> wrote on 11/03/2005 08:56:34 AM: > Hi > > I'm sorry, I'm still slightly confused. The problem is that under > incremental backup I am not often seeing the databases backed up. I now > know that if the db is compacted that will change the dbiid and thus it > will be backed up, but is this enough. > > My position is this. We do a full backup each weekend, so I'm happy with > this. Each day we do an incremental which apparently doesn't back any > databases up, but we do then back up the transaction logs. So I'm happy > that we can restore from the weekly and then roll forward without too much > trouble. > > So can I be happy that things are working as necessary, or should the > database dbiids be changing under other circumstances as well and thus > being backed up during the week also? > > I apologise if I'm just being dumb here :-( > > Many thanks again > > Farren Minns > Solaris System Admin / Oracle DBA > IT - Hosting Services > > John Wiley & Sons, Ltd. ###################################################################### The information contained in this e-mail and any subsequent correspondence is private and confidential and intended solely for the named recipient(s). If you are not a named recipient, you must not copy, distribute, or disseminate the information, open any attachment, or take any action in reliance on it. If you have received the e-mail in error, please notify the sender and delete the e-mail. Any views or opinions expressed in this e-mail are those of the individual sender, unless otherwise stated. Although this e-mail has been scanned for viruses you should rely on your own virus check, as the sender accepts no liability for any damage arising out of any bug or virus infection. ######################################################################