on 2019 May 21 9:30 AM
Hello,
I am trying to connect to a backup of my database without restoring on my server, but just on a localhost.
When I open SQL Central (both v16 and 17) and try to press connect, select action: "Start and connect to a database on this computer", browse my DB-file, write the uid+pw and click connect, I receive the following error:
[SAP][ODBC Driver][SQL Anywhere]Unable to start database server SQLCODE=-80 SQLSTATE=08001
What was displayed in the console log of the server? Was a new server started (ie, a new server name specified) or are you talking to a server that is already running? If a new server is being started, you can specify "-o filename" in the startup parameters.
My guess, however, would be "a database with that name has already been started" or "a server with that name is already running". Either you are trying to start a database with the same file name (and not a new DBN= database name in which case DBN defaults to the database file name) or a server with the same name (ENG= which also defaults to the database name). Specify a unique server and/or database name.
That said, you almost never want to start your backup databases except in read-only mode otherwise you will not be able to apply subsequent logs to it. To use read-only, use use the '-r' switch . You can use '-imv' (in-memory validation mode) which allows the database to go through recovery and do a certain amount of modifications that are only kept in memory and never written to disk.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Instead of using SQL Central, try starting a server with your database, from the command prompt.
dbeng17 -o serverlog.txt -z <path-to-database.db>
or
dbsrv17 -o serverlog.txt -z <path-to-database.db>
If that doesn't work, then you'll understand why SQL Central can't start a server with your database.
If the server starts, then you can connect to the database server with SQL Central using "connect to a running database".
you can try this link: https://learn.sapdigital.com/SQLA-Trial-Registration-Page.html
You need to have either dbengX or dbsrvX executables where X is a major version to host a database file. You will get the error that you have reported if you attempt to autostart an engine and there dbeng17 executable cannot be found (or the engine reference in the START= is not found).
User | Count |
---|---|
68 | |
10 | |
10 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.