Comprehensive data protection for all workloads
Post Reply
barchas
Enthusiast
Posts: 26
Liked: 1 time
Joined: Dec 13, 2011 6:43 pm
Contact:

Sybase mid-transaction, what happens?

Post by barchas » Jun 13, 2012 5:37 pm

Hi all

Im planning out my disaster scenarios and realized a potential issue that I am not quite clear on how it would affect integrity.

We have an old sybase database, pre-vss.
If there is large transaction being committed to the database, and mid-transation veeam starts backing up. I assume the critical moment is the snapshot, which could technically split a transaction across the snapshot boundary. If there was to be a loss of the VM, and a recovery is required, what would happen? Since the DB is not VSS aware/capable, this started to become a concern for recovering a backup that might have been right in the middle of a database transaction. Even though Veeam is backing up at block level, the transaction to the database may not have been completed yet.

I realize this might not actually be a Veeam question, and probably a VMware or Sybase question, but I figured I would start here.
Thanks for any insight.

tsightler
VP, Product Management
Posts: 5442
Liked: 2258 times
Joined: Jun 05, 2009 12:57 pm
Full Name: Tom Sightler
Contact:

Re: Sybase mid-transaction, what happens?

Post by tsightler » Jun 13, 2012 7:24 pm

The same thing that would happen if you hit the "big red button" at that moment. For most databases that means that the logs would be replayed and the uncompleted transactions would be rolled back (i.e. media recovery). I don't think Sybase would be any different.

barchas
Enthusiast
Posts: 26
Liked: 1 time
Joined: Dec 13, 2011 6:43 pm
Contact:

Re: Sybase mid-transaction, what happens?

Post by barchas » Jun 13, 2012 7:28 pm

makes sense of course. Especially now that I have been thinking on it a bit. So i think my real question should be to sybase then.
thanks for the answer.

Post Reply

Who is online

Users browsing this forum: Google [Bot] and 28 guests