Quote:
|
Originally Posted by gaurav1980us
Can anybody help me any script or way to compare the size of two databases , this is helpful in replication server to check whether data is moving from prim. to the source side ...
|
For a Replication Server, to check if data is in sync, you need more than checking a database size.
Some options are.
1) Table Counts
2) Test table, which can show latency. Insert into primary with a timestamp and see when it gets into standby.
3) Application level checks
Check
www.sypron.nl It has some useful tips.
dBforums
>
Script to compare two diff. database size on ASE
11-20-07, 04:48
Linear Mode
