The forum will be down for scheduled maintenance on Saturday, March 4 beginning at 10am EST. Actual downtime is unknown but may be several hours.

I had two databases working via two diffrent services I had created in sybase central. I am using sqla 11.0.1.2584. 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

javedrehman's gravatar image

javedrehman
256141421
accept rate: 0%


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.

-john.

permanent link

answered 10 May '12, 09:38

John%20Smirnios's gravatar image

John Smirnios
8.7k377106
accept rate: 40%

thank u very much john, I just deleted the old log file and started the server and it created an new log file for me. since this is my test database I am not really very keen in keeping log of all transactions, so i could start with a new log file. I will now see if database has the data and if it works fine. thanks for ur help.

(10 May '12, 09:45) javedrehman
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×14

question asked: 10 May '12, 09:02

question was seen: 2,226 times

last updated: 10 May '12, 09:45