On Tue, 17 Jan 2012 11:44:53 +0000, Maya Opperman <[email protected]> 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
