> > I can't answer this directly but since noone else seems to have
> made any
> > comments I would have to pipe up that I think you are going about
> this the
> > wrong way. If there are many users on your system, I would
> necessarily
> > prevent ALL of them from backing up the database and make it an
> activity for
> > the server only.
> > Alan
> > PS - you could shutdown the database from a client who would
> necessarily be
> > SYSDBA and would also require that all other users NOT be SYSDBA.
> Then you
> > could backup without anyone attached.
> > Please tell us why you think you need this ability. What are you
> trying to
> > avoid?
>
> My app almost work this way:
> I have one or several server processes, and several FB databases. All
> the server processes can accesss all the databases (at the same time).
>
> Most of the client apps will only do SELECT requests in the databases.
> I have a special client, for administration only (it creates/removes
> databases, performs manual backups, restore...). This client may be
> used by one person only. Other clients don't do "backup".
>
> There is no issue with SYSDBA or any other Firebird-oriented users.
>
> I can setup automatic backups, which are launched automatically by
> the server process. But I don't want to stop my server during the
> backup preventing the client apps from accessing the data (one backup
> may last one or several hours, with very large databases).

pardon me but this logic seems a little screwy.. why stop the server during
backup? - in fact if you did stop teh server, the backup would fail. I don't
understand you here.

>
> I don't want to launch an automatic backup if another one is running
> (each automatic backup using a different service handle) even for a
> another database. (because it may slow down hard drive performance).

if you have scheduled your nackups you are in control of the timing - still
don't understand you here.

>
> I also want to prevent a user from launching a manual backup/restore
> on a database which is currently being backed up automatically.

this contradicts your outline above.

>
> I have used the "isc_service_query" to wait for the end of the
> backup/restore, but I can't find any way to know if other
> backup/restore services are currently running.
>
> I think I will not use any other kind of service. I can switch to FB
> 2.0 if needed but not right now.
>
> Thanks for your help.
> Bénédicte

if your admin client is only ever used by one client and it is the only
vehicle for requesting backup, then how do you ever get moren than one
simultaneous request... and even if you did get it there is no problem doing
2 backups simutaneously. Restore is far more CPU hungary than backup.
Alan