I. 09/17 06:58:31. SQL Anywhere Network Server Version 220.127.116.1150 I. 09/17 06:59:58. ... recovery 0% complete I. 09/17 19:25:43. ... recovery 50% complete I. 09/18 08:42:31. ... recovery 99% complete I. 09/18 09:10:31. Recovery complete
This was a single log file (6,739,460,096 bytes), with one day of activity. I'm glad I wasn't in a hurry.
We have looked into the transactions in this log file and all look normal. We do not have any tables without primary keys. We are chalking this up to a slower machine and the issue John brought up regarding recovery being single threaded.
answered 19 Sep '13, 14:27