Thank you for your answer.

I try to connect using EMS SQL Manager 2005 for IB/FB. Even with no
other users connected just FlameRobin can access.

I did your tip. Close the connection in FlameRobin and using his
backup option did the backup and it worked.

--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:
>
> At 08:58 PM 30/01/2009, you wrote:
> >Hi Helen,
> >
> >I executed gstat and the Attribute line gives me this:
> >
> >Attributes single-user maintenance
>
> That means it is in a shut-down state but one user may attach to it.
>
>
> >I think it is a flag that got "stuck".
>
> I don't think so. The database state is written (by a bit flag, to
be sure) in the database header.
>
> >Using flame rocbin I can access the database file,
>
> as expected, in this mode. One attachment is OK, more than one is not.
>
> >but I can't do backup to restore it and recover the data.
>
> If you are attached to the database via flamerobin then, in
single-user mode, you can't make a second attachment using gbak. Log
out first.
>
> >Only flame robin can access no other software does.
>
> What other software did you try? And did you try with other
software when nothing else was attached?
>
> >Is there a way to set the attribute manually?
>
> I gave you the correct syntax for putting the database online (a
correction for your wrong syntax that did not work).
>
> ***With *no* connections to the database, did you try it using the
correct syntax?
>
> /opt/firebird/bin/gfix -online -user SYSDBA -password **
localhost:litoral
>
> Do you get any exception when you try that?
>
> You might like to try instead:
>
> /opt/firebird/bin/gfix -online -user SYSDBA -password **
localhost:/litoral/database/ERP_VCONTROL_LIEX.FDB
>
> (although I don't know any reason why gfix would choke on the alias).
>
> ./heLen
>