Skip to Content
0
Jun 27, 2014 at 11:28 AM

Unable to start specified database: dblog.log is an invalid transaction log

1356 Views

Hi,

I am working on SQL Anywhere 12.

I have created a new db and after several weeks of work when I try to start my db from Sybase Central I get following error:

[Sybase][ODBC Driver][SQL Anywhere]Unable to start specified database: baza1.log is an invalid transaction log

SQLCODE=-82

SQLSTATE=08001

When I am trying to start it from command line I get following logs:

I. 06/27 11:48:01. Starting database "baza1" (c:\baza\baza1.db) at Fri Jun 27 2014 11:48
I. 06/27 11:48:01. Database recovery in progress
I. 06/27 11:48:01. Last checkpoint at Wed Jun 18 2014 21:15
I. 06/27 11:48:01. Checkpoint log...
I. 06/27 11:48:02. Transaction log: c:\baza\backup\baza1.log...
E. 06/27 11:48:03. Error: Database cannot be started -- c:\baza\backup\baza1.log is an invalid transaction log

E. 06/27 11:48:03. Database cannot be started -- c:\baza\backup\baza1.log is an invalid transaction log
I. 06/27 11:48:05. Database server shutdown due to startup error
I. 06/27 11:48:05. Database server stopped at Fri Jun 27 2014 11:48

It happened already 2nd time...

Can somebody tell me what could be the reason or how I can find out what is the reason myself?

Thanks,

ak