Copy database file in use in Delphi

Asked

Viewed 276 times

0

I use the Absolute Data Base database. It is an embedded database with multiple network connection feature.

I am making a backup system to copy the . abs file generated by the bank. The problem is that as the file is in use, I cannot perform the copy. I have to disconnect to perform such process.

There is some way to make this copy of the file in use. If the system was networked, all logged in users should be disconnected?

1 answer

0


There is an application called Cobian Backup, in passing it is free. There is an option called shadow copy. By enabling it you can copy the file in use.

Most backup apps have this option.

I don’t know what your case is, but if you’re going to do this programmatically you need to know how to use the shadow copy feature.

Follow link with example code: Code example

  • Thanks, but I already have and use it. I wanted a function to add on my system

  • @André, see the link in the reply.

  • For you, it is impossible to implement a backup service that was triggered at dawn ? I say this, because in addition to the backup, sometimes it may be necessary a Vacuum or something like that. (we used Postgresql, and we had the same problem)

  • Thanks, I’ll check it out. I haven’t seen the link. About shooting this at dawn for this system is unviable, because in 85% of cases, will be used in business hours in single-user mode.

Browser other questions tagged

You are not signed in. Login or sign up in order to post.