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
16●1●1●2
accept rate:
0%
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.