Subject Re: [firebird-support] Hiow to corrupt a Firebird database
Author Mark Rotteveel
On Tue, 17 Jan 2012 11:44:53 +0000, Maya Opperman
<maya@...>
wrote:
> Hi,
>
> I was under the impression that copying a database that is currently in
> use can cause a corruption because windows xcopy might deny the Firebird
> server access to that file momentarily. I was looking for an official
> statement on this for a customer of mine and found this:
>
> http://www.firebirdsql.org/manual/qsg10-howtocorrupt.html
>
> but it doesn't include the copying/zipping of a live database. Is the
> documentation out of date, or is it not an issue any more?
>
> Regards
> Maya
>
> PS. Similarly, in the past, I have also been advise to keep connection
> strings exactly the same from all client connections, but I can't see
> anything on that either

I actually believe (but I am not sure) it is not the original database
that you can corrupt this way, but the copy is very likely to get corrupted
as it will have an inconsistent view of the database content. I do not
think that the (x)copy locks the file when performing the copy.

Mark