Marius Labuschagne wrote:
Can someone tell me if it is possible to query one of the system tables, to retrieve the last date a database was restored?
Norman Dunbar answers:
One method is to:
gstat -header | grep -i creation
That will give you the "Creation date": The date that this database was created originally. It may show the date that the database was last restored by gbak.
In FB 2.x there are the MON$ tables.
Select MON$CREATION_DATE from MON$DATABASE
could be the one you want.