I tried to upgrade a Database from SA version 11.0.1 (build 2744) to version 16.0.0 (build 1823) by unloading the existing database. I used the dbunload.exe (64bit) in the console with the parameters
-c (directly access with path to database) and -ar (because of using SQLRemote). The unload-process was successful without any raiserrors but now i can't start the database-server or backup the database before starting it.

errormessage:

Unable to start specified database: Cannot use log file '%1' since it has been used more recently than the database file

  • Error constant: SQLE_LOG_NEWER_THAN_DB
  • ODBC 2 state: 08001
  • ODBC 3 state: 08001
  • Parameter 1: The name of the transaction log mirror file.
  • Severity: 11
  • SQLCODE: -1016
  • SQLSTATE: 08W80
  • Sybase error code: 840

Do anybody know the problem and have a solution?

asked 10 Sep '14, 09:31

FE_INF's gravatar image

FE_INF
16112
accept rate: 0%

edited 10 Sep '14, 10:00

Volker%20Barth's gravatar image

Volker Barth
30.6k305456662

There is a mismatch between the log offsets according to the database file and the current transaction log.

Have you specified a directory path after -ar?

What files are contained in the database folder and in the offline log folder?

The following doc page (here for v12.0.1) tells some that are done by DBUNLOAD -ar automatically, and that may give some clues. With the help of DBLOG and DBTRAN you may find out why the log offset information does not match.

(10 Sep '14, 09:59) Volker Barth
Be the first one to answer this question!
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:

×201
×137
×78
×53
×41

question asked: 10 Sep '14, 09:31

question was seen: 1,739 times

last updated: 10 Sep '14, 10:00