Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question

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.

share|improve this answer
    
Good answer. Just worth noting that when you run ONLINE DATABASE, any uncommitted transactions are rolled back, no matter when they started. –  Simon Righarts Dec 3 '12 at 1:19

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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