The below process seemed to work - no need for backup/restore (at least at
this point).

I was then able to post the user's entries.

Very cool.

Kevin





_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Kevin Stanton
Sent: Monday, September 10, 2007 11:08 AM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Index unexpectedly deleted



Thanks for all replies.

I'm in the process of getting all users out of the system. I will try:

1) stop/restart the service

2) drop and recreate the index

3) sign on as the user and try to post her entries.

If all that doesn't work, backup/restore here we come.

Thanks,

Kevin

_____

From: firebird-support@ <mailto:firebird-support%40yahoogroups.com>
yahoogroups.com
[mailto:firebird-support@ <mailto:firebird-support%40yahoogroups.com>
yahoogroups.com] On Behalf Of Ann W. Harrison
Sent: Monday, September 10, 2007 10:57 AM
To: firebird-support@ <mailto:firebird-support%40yahoogroups.com>
yahoogroups.com
Subject: Re: [firebird-support] Index unexpectedly deleted

Leyne, Sean wrote:

>
> I would have *all* users logout and try again.
>
> If that doesn't work... then you'll need to "punt" and perform a
> backup/restore.
>

Unless you're using classic, it's probably also worth restarting
the server before you resort to backup/restore.

Good luck,

Ann

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]