Subject RE: [ib-support] What's this mean
Author Wilson, Fred
Mmmmmm, well, that does *not* appear to be the case (IB5.6).. I just started
a restore (after dropping a database), and was able, with no problems, to
log into the database (via WISQL) and do a select * from xxxx...

Fred Wilson
SE, Bell & Howell

-----Original Message-----
From: Claudio Valderrama C. [mailto:cvalde@...]
Sent: Saturday, March 23, 2002 9:39 PM
Subject: Re: [ib-support] What's this mean

""Wilson, Fred"" <fred.wilson@...> wrote in message
> Ann, I'll have the tech at the site run validation and see what it
> Just a thought, could something like this occur if a user (through an
> application) connects to a database which is being restored (after it was
> dropped), and while the restore is in progess, and tries to "work" ??

(While Ann thinks...)
I don't think this is possible. Gbak creates the restore db in a shutdown
state and without forced writes. It does all the data restore, then before
detaching from the newly created db, it sets the db to multi-user mode again
and sets forced writes. If you try to connect in the meantime, you will get:

Statement failed, SQLCODE = -902

Of course, if sysdba tries to connect, it will succeed. Maybe even sysdba
should be forbidden if the previous (and hopefully only) attachment is being
held by gbak, since it doesn't make sense to interfere at this time.
Whatever happens, once gbak exists for good or bad reason, sysdba would be
able to connect anyway, so why allowing it to log in a db being restored?

Claudio Valderrama C. - -
Independent developer
Owner of the Interbase® WebRing

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to