<div>
Thanks for confirming what I thought about setting the compression to none.<br />
<br />
The suggestion of using a PreCommand has possibilities - Robocopy may well be more efficient at the network copy and then BkExec will just be doing a local backup which one would hope will be very quick without any compression enabled. Since there is then a proper backup job it is simple to just create a duplicate job to then archive that to tape.
</div>


<div>
Thanks, One additional comment. I would wonder if backing up the remote resource with Backup Exec first is faster than robocopying the file. The BE Remote Agent on the remote resource pre-processes the files being backed up to help reduce the load on the network and your backup server. Interesting question.
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have various servers running SQL and they each do there own SQL backup to local .BAK files. Currently these files are included in the Weekly and Daily backups to our backup server and so become part of the .bkf files and then are duplicated to tape. This works no problem but I think adds more time than necessary. <br />
<br />
Does Backup Exec 11d have a function where I can copy the *.BAK files without doing a backup of them and then duplicate that copy to tape? From what I have read this can only be achieved via a scheduled robocopy or something similar but then I don't see how the duplicate would work. <br />
<br />
For the time being getting Backup Exec to do the actual SQL backups is not an option but it is something which is being proposed.<br />
<br />
Thanks,<br />
<br />
keyguard<br />
<br />
The reason that I do not want to backup the *.BAK files is that the restore procedure then becomes longer and the backup is longer as well I assume as Backup Exec will try to compress the files, or will this not be the case with compression completely disabled? 
</div>
</div>


Hi,

I have various servers running SQL and they each do there own SQL backup to local .BAK files. Currently these files are included in the Weekly and Daily backups to our backup server and so become part of the .bkf files and then are duplicated to tape. This works no problem but I think adds more time than necessary. 

Does Backup Exec 11d have a function where I can copy the *.BAK files without doing a backup of them and then duplicate that copy to tape? From what I have read this can only be achieved via a scheduled robocopy or something similar but then I don't see how the duplicate would work. 

For the time being getting Backup Exec to do the actual SQL backups is not an option but it is something which is being proposed.

Thanks,

keyguard

The reason that I do not want to backup the *.BAK files is that the restore procedure then becomes longer and the backup is longer as well I assume as Backup Exec will try to compress the files, or will this not be the case with compression completely disabled? 

Copy Job in Backup Exec

The term "Backup" means the methods and processes involved to copy computer data (system data as well as application data) to media other than the ones where the data originally live (disk, tape, optical, cloud). "Restore" in turn means the methods and processes involved in data recovery, i. e., bringing back copied computer data to their original location. Backup/Restore primarily serves as a means of protection against data loss, be it due to disaster, corruption or sabotage. It can also be used for recovering data from an earlier point in time and even for cloning machines or applications. There is a wide variety of backup/restore software available, from expensive commercial products to free or open source tools.