SEO

Hi,
Can I get the following by querying the sybase data or (more likely)
backup server:
1. An online database's last dumped transaction log file name and
timestamp
2. A standby database's last applied transaction log file name and
timestamp.

I know the above can be obtained from the sybase backup server log
(text file) but want to see if I have a choice of getting it from the
servers.

Thanks in advance,
Ranjit

On Apr 11, 7:02 am, ran...@sanovi.com wrote:
> Hi,
> Can I get the following by querying the sybase data or (more likely)
> backup server:
> 1. An online database's last dumped transaction log file name and
> timestamp
> 2. A standby database's last applied transaction log file name and
> timestamp.
>
> I know the above can be obtained from the sybase backup server log
> (text file) but want to see if I have a choice of getting it from the
> servers.
>
> Thanks in advance,
> Ranjit


This information is not stored by default in ASE.

a) You could set a business rule that all dumps and loads are to be
done through a set of stored procedures that log this information into
a table.

b) If all dumps and loads are done manually (i.e. not via thresholds),
then you could have them all done by a dedicated login and audit the
"cmdtext" for that login. You could then query the audit tables in
sysaudits (and something to extract and store seperately the latest
row for each database whenever you truncate the audit table).

c) With the XFS (external file system) feature, you could create a
proxy table on the backupserver errorlog and extract the information
from the proxy table.

Thanks, Bert.
This requires some intrusive access to the database setup and most of
our clients would prefer to leave it untouched. For now, I will stick
to parsing the backup server log file. Thanks.
Regards,
Ranjit