SQL Full and Incremental in the same script?

[Michel_Steiner]

With the NetBackup SQL client, is it possible to have a full backup of DB "master" and an incremental of all the other DBs in the same script? I tried the following script. The first "BACKUP OPERATION" alone works fine, the second also works fine if alone in the script. But together in the same script, they fail (error 2 if started from the server, no error no log if started from the client).

NB 5.1 MP1


OPERATION BACKUP
DATABASE "master"
NBSERVER "SRV-BCK-01"
VDITIMEOUTSECONDS 7200
MAXTRANSFERSIZE 4
BLOCKSIZE 7
BUFFERS 16
ENDOPER TRUE

OPERATION BACKUP
DATABASE $ALL
EXCLUDE "master"
DUMPOPTION INCREMENTAL
NBSERVER "SRV-BCK-01"
STRIPES 2
VDITIMEOUTSECONDS 7200
MAXTRANSFERSIZE 4
BLOCKSIZE 7
BUFFERS 16
ENDOPER TRUE

[Martin_Falk]

I don't know why you would do a constellation like this.
You do the incremental backup to backup and truncate the transaction logs. If you do a full backup the logs get backupped and truncated too. I would make more sense to me if you create 2 scripts in 2 policies that do the job on different times of the day.
For example: FULL at night and INC (transaction logs) around afternoon.


Best Regards

Martin

------------------------------------------------------------------------
http://www.netbackup-usergroup.de.vu