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 18.104.22.16803 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
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.