09-12-2016 10:05 AM
Hi,
I had added CONVERTBACKUP TRUE in the batch file of a differential SQL backup (Based on page 185 in 7.7.2 sql admin guide). The backup shows this error and ends with status 2.
09/12/2016 08:49:15 - Info dbclient (pid=5260) USER - You provided an illegal keyword: <CONVERTBACKUP>
I would like to add convertbackup for both differential and transaction log batch files.
Can you Please let me know how to resolve this.
Thanks.
09-12-2016 09:18 PM
How does your bch file syntax look like?
Try this in my test script, works fine for me.
OPERATION BACKUP
DATABASE $ALL
SQLHOST "sqlmnt01"
NBSERVER "win2008mas"
STRIPES 2
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
CONVERTBACKUP TRUE
ENDOPER TRUE
Assume your SQL host is already at NB7.7 or above. Actually if you use the SQL Intelligent Policy, you don't have to worry about the syntax, there is now a GUI for you to choose that setting and many others.