Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 5 of 5 total |
It apears Acronis backup is locking EDB tables |
Thu, Feb 12 2015 11:20 AM | Permanent Link |
Barry | If I have my application running (at night) when Acronis is backing up my hard drive, I will see an EDB Error 300 saying the table is locked. Each night it can be a different table. This is unusual since no one else is using the database except for my one application.
So do I assume I have to exclude the EDB database directory from the Acronis backup and just backup the EDB backup in the Stores directory? Is this the normal course of action when an application is running 24/7? TIA Barry |
Thu, Feb 12 2015 11:46 AM | Permanent Link |
Matthew Jones | Barry wrote:
> So do I assume I have to exclude the EDB database directory from the > Acronis backup and just backup the EDB backup in the Stores > directory? Is this the normal course of action when an application is > running 24/7? I'd say so yes. One of my service applications does a backup in the evening to a directory that must be outside the application data location, with instructions for it to be backed up. Keeping other systems away from opening your data files for reading isn't a good thing. Disk image wise, perhaps okay, but not at file level. -- Matthew Jones |
Thu, Feb 12 2015 1:06 PM | Permanent Link |
Barry | "Matthew Jones" wrote:
>I'd say so yes. One of my service applications does a backup in the >evening to a directory that must be outside the application data >location, with instructions for it to be backed up. Keeping other >systems away from opening your data files for reading isn't a good >thing. Disk image wise, perhaps okay, but not at file level. Thanks for the feedback. I have my Delphi app and EDB database under the directories: c:\ProgramData\CompanyName\AppName c:\ProgramData\CompanyName\AppName\Data\DBData c:\ProgramData\CompanyName\AppName\Data\Stores If I just have Acronis exclude the directory: c:\ProgramData\CompanyName\AppName\Data\DBData I think I should be ok because Acronis will backup the Stores directory that has the EDB backup from the same day. Do you see any problem with this? TIA Barry |
Thu, Feb 12 2015 2:34 PM | Permanent Link |
Raul Team Elevate | On 2/12/2015 11:20 AM, Barry wrote:
> If I have my application running (at night) when Acronis is backing up my hard drive, I will see an EDB Error 300 saying the table is locked. Each night it can be a different table. This is unusual since no one else is using the database except for my one application. I thought Acronis would do a shadow copy based backup which should not lock anything so this is somewhat surprising. I have not used Acronis for a long time though so can't advise but i would suggest checking what backup methods it exactly runs (assuming there is a choice). For regular (file system) based backups yes you can run into locking issues. I'd say exclude the EDB folders and instead use EDB built-in backup (and make sure you backup the catalogue also) and then include the resulting file in the acronis backup. Raul |
Fri, Feb 13 2015 3:57 AM | Permanent Link |
Matthew Jones | Barry wrote:
> Do you see any problem with this? Looks good from my point of view. -- Matthew Jones |
This web page was last updated on Thursday, May 23, 2024 at 07:54 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |