Hi Stephen, you are right. A full data base backup with checkpoint could take longer than a backup with savepoint. In case of a backup with checkpoint the SQL locklist will be closed and the proper backup has to wait until all open transactions are closed. After the checkpoint has finished and the backup is working the SQL locklist will be open again!
The checkpoint backup has the advantage that no log is needed to recover the data base, because no transaction was open. Full data base backups with savepoint are useless without log in SAP DB 7.3 (but not in SAP DB 7.4!) Our experiences with commercial customers has shown that the checkpoint technic is bad because the data base could blockade and therefore we decided to remove the checkpoint technic in SAP DB 7.4 Regards, Torsten SAP DB, SAP Labs Berlin -----Original Message----- From: Stephen Gutknecht (SAPDB) [mailto:[EMAIL PROTECTED]] Sent: Mittwoch, 9. Oktober 2002 18:26 To: '[EMAIL PROTECTED]' Subject: SAPDB backups - disadvantage of doing checkpoint Hi, Can someone tell me what disadvantage there is to doing a checkup backup when doing a full backup? If I'm understanding... Does the backup _wait to start_ until all pending (database user) transactions are completed (COMMIT / ROLLBACK)? This means it might just take a few extra seconds or minutes before it starts doing the backup, right? In other words: It slows down the backup steps a little, it doesn't put locks on the database or anything that would impact active users. Or do I have it all wrong? Thank you. Stephen _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
