Subject Re: [firebird-support] Getting the Last Date a Database was Restored
Author Norman Dunbar
Evening Marius,

>> Can someone tell me if it is possible to query one of the system
>> databases, to retrieve the last date a database was restored?

One method is to :

gstat -header <database> | 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 coule be the one you want.


HTH


Cheers,
Norman.