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

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

"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

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

Barry wrote:

> Do you see any problem with this?

Looks good from my point of view.

--

Matthew Jones