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

pmjwales
21113
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

Martin
9.0k130169257
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

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:

×108

question asked: 30 Oct '12, 07:58

question was seen: 1,217 times

last updated: 30 Oct '12, 09:59