On Apr 9, 10:56=A0am, ThanksButNo <no.no.tha...@[EMAIL PROTECTED]
> wrote:
> On Apr 8, 9:25 pm, ran...@[EMAIL PROTECTED]
wrote:
>
> > For monitoring a sybase disaster recovery site I am trying to get the
> > following information from the sybase server:
> > =A0 =A0 =A0 =A0 1. Last DUMPED transaction id and its timestamp from
an =
online
> > database.
> > =A0 =A0 =A0 =A0 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'" =A0two 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 =A0its 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]
|
