Hi Norman

Appreciate your input.

I attempted to shutdown the database with the command in IBExpert. It
hung so I had to abort the process.

FB was and is running (I have 8 applications running on the server so
could not shut it down but will do tonight).

This was a scare as the database is toast but I hope the FB restart will
resolve it.

Meanwhile I copied the database file (hate doing that) and validated
that copy for the client to continue working on. (Had that failed I
would have resorted to backup.

Regards
Tony

Norman Dunbar wrote:

>
>
> Morning Tony,
>
> > Tried both but they both return the same result ie
> > database C:\BOOKSYS\ArtistTek\ARTISTTEK.FDB shutdown.
>
> How exactly did you shut down the system?
>
> It sounds to me as if the firebird server is not running. As this
> appears to be a windows box, given the file names, you need to have a
> look here - http://www.firebirdsql.org/manual/fbmgr-win.html - for the
> docs, but ...
>
> * Check in control panel->administration->services to see if the
> Firebird service and guardian) are running. If not, start them. You can
> do that in control panel, or on the command line:
>
> c:\> instsvc stop
> Service "Firebird Guardian - DefaultInstance" successfully stopped.
>
> c:\> instsvc start
> Service "Firebird Guardian - DefaultInstance" successfully started.
>
> * Now try bringing the database online again using gfix:
>
> c:\> gfix -online normal <database>
>
> * You should *not* need to restart the actual physical server that
> Firebird is running on.
>
> In summary, you need to be sure that the Firebird server (services) is
> running and that the database has been brought online.
>
> Cheers,
> Norman.
>
> --
> Norman Dunbar
> Dunbar IT Consultants Ltd
>
> Registered address:
> Thorpe House
> 61 Richardshaw Lane
> Pudsey
> West Yorkshire
> United Kingdom
> LS28 7EL
>
> Company Number: 05132767
>
>