Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in August and this forum will be retired.

I have a db file but no log file from someone who has asked me to write a couple of infomaker reports. They can't get back to the pc where the data is held for a couple of weeks. is there anyway to get the db running ?

asked 30 Oct '12, 07:58

pmjwales's gravatar image

accept rate: 0%

start it with dbeng9 -f or use dblog -n to change the DB file to not use a transaction log.

permanent link

answered 30 Oct '12, 08:35

Martin's gravatar image

accept rate: 14%

thanks very much that got me going.

(30 Oct '12, 08:50) pmjwales

Note that any transactions that were committed in the log that was missing will not be present in the database once you use -f. You won't be able to apply those transactions automatically via recovery either. The best you could do is translate the missing logs once you get them and execute the translated SQL statements.

(30 Oct '12, 09:59) John Smirnios
Your answer
toggle preview

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 30 Oct '12, 07:58

question was seen: 1,253 times

last updated: 30 Oct '12, 09:59