On Apr 8, 9:25 pm, ran...@sanovi.com wrote:
> For monitoring a sybase disaster recovery site I am trying to get the
> following information from the sybase server:
> 1. Last DUMPED transaction id and its timestamp from an online
> database.
> 2. Latest APPLIED transaction id and its timestamp on a
> database in "online for standby access" state.
> Here, the second database is receiving transaction log files that were
> dumped from the first database server. To provide an example, assume
> someone did "dump transaction <dbname> to 'filename'" two days ago.
> Today I would like to run a query on the sybase data or backup server
> to obtain the last dumped transaction id and its timestamp (and not
> the time of issue of the "dump transaction" command).
>
> I have checked the system tables and some dbcc commands but did not
> get this info. Is there a way to get the above data?

I can't help you get this information, but I'd
love to know why you'd ever need it!

<;-)