Exactly! Even with proper direct write configuration of the USB drive
, I still occasionally experience "Delayed Write Failed" errors. So,
my question is this: What is likely to happen to a FB DB when a write
fails? Will the DB be corrupted? Will it be recoverable? Or will
everything be fine, just data from the failed transaction missing?

Nathan

--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:

>
>
>
> > Thanks to Helen and others for answering my ODS question...
> >
> > The next concern I have about FB as a solid solution for our project
> > is this:
> >
> > "Our database will reside on a USB-attached disk with the server
> > running on the host system. Of course, end users will simply unplug
> > the drive without shutting us down first. What is likely to happen
> > (under Windows) to a FB database that is unplugged at unpredictable
> > (and probably the worst possible) times? Will the whole db be lost?
> > What are the recovery options? Anything I haven't considered?"
>
> Well, from personal experience, I can tell you that ANY
> file write operation can be lost, eg: a simple "copy file"
> in Windows explorer can be lost if you do not "detach" it
> properly.
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle &

MS SQL

> Server
> Upscene Productions
> http://www.upscene.com
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>