---In firebird-support@yahoogroups.com, <maciejlik@...> wrote : ... > Before making repair the database checked the database are logged 2 users > SYSDBA (server and client). In this case, > the command gfix not block access to the database - not disconnect the user > SYSDBA client. ...
> What command to use before taking any remedial action on the database > Firebird to disconnect a user SYSDBA (client)? Read http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gfix-dbstartstop.html#d0e30113 http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gfix-dbstartstop.html#d0e30113 carefully and choose what you really need. For example, you may want to get of all users from db (including SYSDBA): gfix -shut full -force 0 ...then allow single attachment... gfix -online single ...to validate database... gfix -v -full ...and finally bring database online for all users gfix -online Hope it helps, Vlad
