I have a Sybase 15.5 database which is backed up every night using the DUMP DATABASE command. The process takes about 30 minutes.

What happens to the transactions that occur within those 30 minutes? Are they included in the backup or ignored?

1 Answer 1


The dump process happens in 3 phases:

  1. All data and log pages are dumped.
  2. Data pages modified during phase 1 by non-logged operations are dumped.
  3. Log pages are dumped again.

Everything happening until end of phase 2 are contained in the dump. But the changes performed during phase 3 will be missing. Of course phase 3 is pretty fast, so the chances are that you'll not be missing anything. You can check the state of your transaction log after the dump. If anthing is in there, then you know these transactions are not in the dump.

But of course transactions happening afterwards will not be in the dump either so I guess it's not much of an issue.

If your concern is that you dump multiple databases and the dumps might be out of sync, you should consider using quiesce database.

  • Good answer. Just worth noting that when you run ONLINE DATABASE, any uncommitted transactions are rolled back, no matter when they started. Commented Dec 3, 2012 at 1:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.