Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Backup prior to COMMIT in transaction
Wed, Jul 2 2008 10:41 PMPermanent Link

Phil Read
Hi All,

Just a really easy question regarding the backup function. If I'm
running a COMMIT / ROLLBACK transaction and making changes to records /
tables, then just prior to COMMITTING the transaction I use the backup
funciton, will it be a backup of the database prior to the transaction
even starting OR will it be a backup containing changes made during the
transaction.

I'm sure it will be the data prior to the transaction, but I wanted to
make sure and also is this an OK thing to do?

Thanks,

Phil
Thu, Jul 3 2008 8:31 AMPermanent Link

Fernando Dias

Team Elevate Team Elevate

Phil,

If you start a backup inside a transaction, the transaction will commit.
You can find detailed information about this here:
http://www.elevatesoft.com/manual?action=mantopic&id=dbisam4&product=b&version=2006&category=1&topic=12

Also, the backup operation will automatically put a read lock in the entire
database, preventing other sessions from performing any writes to the
database until the backup completes.

--
Fernando Dias
[Team Elevate]

Image