cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to open or restore the db files

Former Member
6,310

I am facing issues to restore the SQL anywhere database provided to me. When I am trying to restore the database I am getting the following error:

The database archive could not be restored. Error during backup/Restore: Unable to open the device. Unknown err status reading HDR labels.

When I am trying to open it using SQL anywhere I am getting the following error:

The database could not be started on the server. Unable to start specified database: the database was created by a different version of the software.

I am Using Sybase central 6.0.1 and SQL anywhere 12.0.1.

Any help would be appreciated.

-- Regards, Abhishek.

VolkerBarth
Contributor

So what version has the database been created with?

From the v12.0.1 docs:

Sybase Central only supports SQL Anywhere versions 10x and later databases
Support for version 9 database servers and databases created with version 9 software has been removed from the SQL Anywhere plug-in. When unloading and reloading the database into a reload file, or into a new or existing database, you can still connect to a database created with version 5, 6, 7, 8 or 9 software running on a version 9 or later database server.

Former Member
0 Kudos

Thanks for the reply. The database has been created with SQL anywhere version 9.0. I am even trying to unload the database(created in version 9.0) using version 12.0 but it is taking loads of time...

reimer_pods
Participant
0 Kudos

As Volker wrote, SA12 won't open a database created with ASA9 or previous versions. So if there's no ASA9 engine available to you, unloading the database to be rebuild into a new SA12 db looks like your only choice. In my experience the fastest way is to unload directly into a new database.

Accepted Solutions (0)

Answers (0)