All, SAPdb (7.3.0.35)
I wanted to verify I was on the right path. I've created scripts to generate uniquely named media for log backups, and then execute that media every 10 minutes. When the DB is not active it does not backup and outputs a -123 error which means it has no or very few changes to backup. I understand the "no" part, but the very few has me worried. It seems that an inactive DB still generates 1 page (8k) of logs every 2 hours and 40 minutes, and then it'll actually make a backup. My concern is that if very few changes are made to a system it could take hours before it actually gets backed up, is this correct? Here's what I'm thinking and please verify if I'm thinking correctly, with 10 minute log backups I have the potential to loose up to 9 minutes and 59 seconds (roughly due to the time it takes to actually execute the script, then backup) and/or 7.9k of data? Thanks for your time, Chris