The message we are getting in error log of standby sybase server is as below
Recovering last page of log (was 2741508, now 2741507)
It occurs just few seconds before the load transaction completes and the next load transaction fails giving the error 4306 which says "There was activity on database since last load, unable to load. Must restart load sequence with the load database to continue."
Explanation from sybooks: If user transactions modify the transaction log between transaction dump loads to a database, Error 4306 occurs and the load fails. Error 4306 would only occur if someone ran the online database command for the database, someone did work in the database, and then you tried to do a load transaction for the database. Begin again with a load database or proceed to use the database without recovering all transactions.
The same error is raising many times.
We tried to load database and then load transaction to some other server it stops at the same point
It has not affected the business s this error is shown in stand by database
Version of both the servers is:
Adaptive Server Enterprise/12.5.3/EBF 13331 ESD#7/P/NT (IX86)/OS 4.0/ase1253/1951/32-bit/OPT/Fri Mar 24 02:17:56 2006
thanks in advance
Software/Hardware used: windows 2003 sybase 12.5.3 ebf 13331
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!