Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 3 of 3 total |
Backups |
Wed, Sep 12 2007 7:18 AM | Permanent Link |
During a backup, is there any way to get a normal query to work?
It seems that a backup causes a read lock on the tables. I'm pondering how to get this to work sensibly - possibly keeping a note of when the last transaction was and waiting for 10 mins. The backup should be done in the middle of the night when no one is around, but I'm also coding it to make a backup 5 mins after opening if it hasn't done one recently, and of course that's an awkward time if the backup takes a minute or two. Any thoughts on this issue welcome! /Matthew Jones/ | |
Wed, Sep 12 2007 1:11 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Matthew,
<< During a backup, is there any way to get a normal query to work? It seems that a backup causes a read lock on the tables. >> Sure, you should be able to read the tables just fine during a backup. The only restriction is that a backup prevents any writes to the tables. -- Tim Young Elevate Software www.elevatesoft.com |
Thu, Sep 13 2007 5:04 AM | Permanent Link |
Thanks - I'll work out where I'm failing then. Hmm, instant thought is
that I think I write a "last seen" time. I'll stop that if backup is active and see if that fixes it. Many thanks for the confirmation that it is me. /Matthew Jones/ |
This web page was last updated on Tuesday, April 23, 2024 at 08:10 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |