Thanks Lester Caine.

Yes, in the C/S part we ensure that all the users are disconnected before doing a restore. Now the complication has come because of Apache. 'Restore' is used only when something happens to the DB and is very rarely used by our customers.

Best regards,
Bala

--- In firebird-php@yahoogroups.com, Lester Caine <lester@...> wrote:
>
> Balagopal wrote:
> > We have a C/S application that uses Firebird (2.1). Recently we made a web extension to this application using PHP. We have a back-up/restore utility as part of the C/S software. The restore function (this copies the backed-up database file to the actual location) fails if Apache is connected.
> >
> > Any way to do restore when Apache is connected?
>
> Basically ... NO ... the database has to be shut down to single user mode for a
> restore, but why would you want to run the restore onto the live database? It
> would be better to restore to a new database and then simply switch them,
> although personally I rarely restore the copy that I am working with. Just
> restore a nightly backup to a new file to ensure that there are no problems with
> the backup.
>
> --
> Lester Caine - G8HFL
> -----------------------------
> Contact - http://lsces.co.uk/wiki/?page=contact
> L.S.Caine Electronic Services - http://lsces.co.uk
> EnquirySolve - http://enquirysolve.com/
> Model Engineers Digital Workshop - http://medw.co.uk//
> Firebird - http://www.firebirdsql.org/index.php
>