Using Backupexec 12.5 to backup TRN logs

Why are you not using SQL Agent to perform log backup? It is a method of SQL backups. That ways, you will not require backup using any other utility, and just Backup Exec backups would be sufficient. These errors cannot be avoided, if you are using any other application or SQL internal utilities to perform log backup. So, other utilities or tools need to be avoided, and only Backup Exec should be used. Otherwise, restores would be an issue as some sets would not be controlled by Backup Exec. So, the only way out is to use Backup Exec as a single solution for your backup strategy. Or, you may do a full backup everytime you have done a log backup using other utility, so that the sequence can be re-established.

Please mark it a solution, if this is useful.
Thanks

Hi,

Thanks for responding. I want to only use Backupexec agent, my question was: how do I run hourly backups of the trn logs if tape media is not available every hour?

Thanks
Lozloz

You may run hourly backups to disk, and then towards the end of day, you can schedule a duplicate backup job to tapes. use policy for this implementation. So, create a policy and create following templates in it:
1. Full backup template.. target to tape.
2. Log backup template.. schedule every hour.. target to disk.
3. Duplicate backup template.. schedule every day.. may be and target to tape to duplicate incremental backup template.

Hope this answers.
Thanks

Thanks Hemant,

That does answer my query. Can you offer any advice on my comments about full SQL backups in BE not truncating the trn logs. How do you get around this?

Regards
Lozloz

Thanks