Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

Hello all, I would like to use the command for backup database: "dbbackup -c "..." -k 'recover' -d -t -x -y d:\temp". Unfortunately with the "-k" command does not work. Could you help me please, how to back up database, to be able to run the validation of backup? The current validation reports an error me:

D:\Temp>dbvalid -c "dbf=D:\Temp\db\backup\cis.db;uid=dba;pwd=sql" SQL Anywhere Validation Utility Version SQL error (-82) -- Unable to start specified database: D:\Temp\db\backup\cis.db cannot be started read-only because it requires recovery

I try command dbvalid -c "dbf=D:\Temp\db\backup\cis.db;uid=dba;pwd=sql;dbs=-r". But it is the same.

asked 21 Dec '16, 06:25

Mirek's gravatar image

accept rate: 0%

The use of the "-k recover" switch requires the backup to be a server side backup.

Without also specifying the "-s switch" you will likely be getting a "usage: " listing instead of an error. If that is not what you are seeing maybe you can tell us how it is failing for you.

Note: server side backups also mean the target directory will be relative to the server process.

permanent link

answered 21 Dec '16, 13:07

Nick%20Elson%20SAP%20SQL%20Anywhere's gravatar image

Nick Elson S...
accept rate: 32%

edited 21 Dec '16, 13:08


Thank you, it works.

(22 Dec '16, 06:17) Mirek
Replies hidden

That's great you got it working. Can you accept Nick's answer - click the white tick in the grey circle on the left head side of Nick's answer. That way anyone with the same problem in the future will see that the question was answered successfully. Thanks.

(22 Dec '16, 06:48) Justin Willey
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 21 Dec '16, 06:25

question was seen: 1,932 times

last updated: 22 Dec '16, 07:00