With SA 22.214.171.1248, I'm having problem applying some transaction log.
We have a process that backup and truncate the transaction log every hour and then send the log on another server. On the other server, we have a copy of the DB and every X minutes, apply received logs. This process worked perfectly for years, but since we upgraded to SA16 from SA9 a few months ago, some logs cannot be applied because of the following error:
Error: Cannot open transaction log file -- Can't use log file "F:\oiiq\190176.log" since it has been used more recently than the database file
First thing I thought was that a log was missing (happened before), but after some checking this does not look like the case. Looked into the file backup.syb and no other backup was logged. I translated the last log successfully applied I noticed something strange, there is no checkpoint at the end, all the log I translated always had a checkpoint at the beginning and at the end. Also the log only contained about 20min of transactions. Another thing I noticed, usually when a log pass about 10k in size, once translated the resulted .sql file will be larger than the .log, in this case a 196k .log gile result in a 30k sql file, maybe it's nothing.
With all of this, I have the impression that log is missing or not applying some data.
I have the same problem on 3 completely different setup (client) and working ok on about 50 others.
Any thought ?
asked 19 Jan '15, 15:12