Subject | RE: [firebird-support] Reboot to Restore |
---|---|
Author | Alan McDonald |
Post date | 2005-07-23T00:19:09Z |
> I'm restoring a 600 meg FB 1.0 database to a dev machine quiteone way is to replicate to the web hosted database. That avoids it all.
> 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
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