Subject Re: Can overwrite database file while open - FB 2.5
Author technisoft2005
--- In firebird-support@yahoogroups.com, Michael Ludwig <milu71@...> wrote:

> > I use the Windows explorer to copy the file from sf1\DATA.FDB into the
> > files folder, even though files\DATA.FDB is open it succeeds.
>
> Okay, you're clobbering your database.

Sure, but I don't think that this was possible with FB2.1 and a superserver installation.

> There certainly are limits to any given software's resilience.

Yes, but if it is a simple as putting a lock on the file, should it not do it? People do make mistakes.
Maybe there are technical constraints in FB2.5 which do not allow this solution?

I discovered this by accident on my development machine, so no big deal, but it has some implications for being ultra careful with running production databases.