There are many types of "HA", each with their own costs and cutover
timeframes. There are many levels of comparing the content of
databases, to identify whether the are the "same". From your question,
I assume you are performing log shipping (dump tran source_db, load
tran target_db). In this case, the detail with the dbs do not need
comparison, just the dump/load times.
master.sysdatabase.dumptrdate show the dump time, but not the load time.
For log shipping implementations, which are based on scripts, it is
easy enough to find out from that level, which tran dumps:
- had any data
- got shipped
- got loaded
Of course, a good set of scripts would be logging everything, including
err msgs, and a bad set of scripts means you will have to look at the
file creation date, when a script last executed, etc., but essentially
you need to look at that (script) level to find out.
Senior Sybase DBA / Information Architect
Copyright © 2008 Software Gems Pty Ltd
Quality Standards = Zero Maintenance + Zero Surprises
Performance Standards = Predictability + Scaleability