on 2016 Dec 21 6:25 AM
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 12.0.1.4403 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.
Request clarification before answering.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you, it works.
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.
User | Count |
---|---|
52 | |
6 | |
5 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.