Balagopal wrote:

> 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.

On Linux, I just restart Apache, which frees up the persistent connections, and
then I can 'swap' the database file that is attached to the alias. Although I do
sometimes simply change the database reference in the PHP config to get things
working again quickly. It IS such a rare event that any more 'automated' methods
seem a little overkill ...

--
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