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. (We use DRM, and the MOVE DRM * SOURCE=DBS sent the snapshot offsite and left the full alone). That seemed like overkill, so I changed the "onsite" backup to do a full backup on Sunday and an incremental other days. But at two hours for a full backup, and almost as long for an incremental, I'm wondering if we're still spending more time than necessary backing up our database. Does anybody else see the need for two daily backups? I think the likeliihood of a disaster requiring a database restore is so slim that a single offsite copy might be enough, especially since our "offsite vault" is less than a 5-minute walk (which raises another issue, but thats what we're living with).
Does anybody mess with full/incremental database backups? Or, if I'm only going to do one backup a day, would it make more sense to do a full every day, to simplify things if I do have a disaster and need to restore? --
Matt Simpson -- OS/390 Support 219 McVey Hall -- (859) 257-2900 x300 University Of Kentucky, Lexington, KY 40506 <mailto:[EMAIL PROTECTED]> mainframe -- An obsolete device still used by thousands of obsolete companies serving billions of obsolete customers and making huge obsolete profits for their obsolete shareholders. And this year's run twice as fast as last year's.
