The only data validation you really need to do is to verify how far behind
the secondary server is. If your data contains some time series values that
have a valid business meaning, you can use that. Alternatively, you can set
up a dummy table on the primary server and have a job update it regularly to
insert the current date time stamp. Then, you can just check that dummy table.

Linchi