cancel
Showing results for 
Search instead for 
Did you mean: 

SQL - adding CONVERTBACKUP TRUE in batch file.

Peaches_K
Level 3

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.

 

 

 

 

1 REPLY 1

watsons
Level 6

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.