On Mon, 2005-05-16 at 15:58 +0200, Helmut Tschemernjak wrote:
thank you for the info, another possible problem is that I cannot backup the database e.g. "begin exclusive" and copy the entire DB file while the main server app is still running. The copy aborts at offset 1GB.
This is only a problem on windows. (Unix lets you make a copy of the file even though it is locked - unix got this part right.)
A easy work-around would be to write a custom "copy" program that ignored bytes 1GiB through 1Gib+510.
If you are a member of the Windows "backup operators" group, you can CreateFile (open the file) with the flag FILE_FLAG_BACKUP_SEMANTICS. I *think* you can then copy a locked file.
Gert