Hi I am pretty new to sybase.
I need to find last dump(backup) database date and
last restore(load) database date for my sybase 11.9.2 server's database.
Wht system table or command will help me?
Like in sql server there is atable that shows history of last db backup or restore dates,is there anything here?
Please let me know
Thanks a lot
It sounds like you want the last actual database dump time as opposed to a transaction log dump time. As previously mentioned, if you have the MDA tables (aka monitoring tables) installed, then you can run the following query:
select DBName, BackupStartTime from master..monOpenDatabases
However, with regard to the last restore time, I'm not sure if you can get this from the mon tables or not. Best to look at the backupserver log file which will hopefully (for your sake) be in its default location which will be something similar to:
Look for the latest:
LOAD is complete (database yourdbname)
in the log. Be sure it was the lastest load your found, not an earlier one.
The dumps are also recorded here of course. Look for:
DUMP is complete (database yourdbname)