I had two databases working via two diffrent services I had created in sybase central. I am using sqla 22.214.171.12484. I just copied the .db and .log file from on database location and copied it over on the other to make them both identical that i needed to do for my test. The service I copied from works fine but the one I copied to gives me this error when I start it:
not expecting any operations in transaction log
how do i fix this error, is it even possible to start this database with fresh log file instead of using one from that i copied from other location. thank you very much
asked 10 May '12, 09:02
The database and log don't quite match. Essentially, the message indicates that the log contains "future operations" even though the database looks checkpointed as if it were from a backup or from a clean shutdown.
Are the database and/or log from a backup? Were they running on a UNIX system where perhaps you copied them while they are in use (which we can't really prevent on UNIX)?
If the database or log is from a backup, try the following: dbsrv12 -a foo.log foo.db (The server will then shut down if the log is successfully applied)
Then start your server again.
Since the database looks cleanly checkpointed, you might also get away with just deleting the log but you will lose whatever those "future" (relative to the database) transactions were.
answered 10 May '12, 09:38