Subject RE: [firebird-support] Reboot to Restore
Author Alan McDonald
> I'm restoring a 600 meg FB 1.0 database to a dev machine quite
> frequently, using the old ibConsole that came with Firebird 1.0.
>
> I can't remember the exact message, but the restore won't start
> because there is apparently still a user. This is accessed only by a
> web app, so I stop and start the w3svc to be sure there are no users
> connected.
>
> Still won't work unless I reboot.
>
> Any ideas why this is a problem? How can I get rid of all
> connections?
>
> Thanks,
>
> Kyle

one way is to replicate to the web hosted database. That avoids it all.
another way is to have your web app show a "website under maintenance"
message and you edit the connection file of the web app to stop people
connecting. wait, then restore.
You can also restore to another file on the server (not the active one),
then do the same as just mentioned but this time the down time is shorter
since you only have to rename the file as soon as the last connection has
timed out. (you keep testing to rename the old file, when the OS lets you
then you know the connectiosn have timed out).

Alan