Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 2 of 2 total |
Backup prior to COMMIT in transaction |
Wed, Jul 2 2008 10:41 PM | Permanent 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 AM | Permanent Link |
Fernando Dias 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] |
This web page was last updated on Thursday, March 28, 2024 at 08:36 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |