On Apr 9, 10:56*am, ThanksButNo <no.no.tha...@gmail.com> wrote:
> 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!
>
> <;-)

The easiest way you can do this is to have a look at backup server log
file for both the servers and locate when dump tran /load tran was
happened last.

HTH
Manish Negandhi
[TeamSybase Intern]