Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 565
  • Last Modified:

Schedule Backup Exec 2010 SQL Transaction Log Backups

I was wondering if anyone had a good way scheduling SQL Transaction Log Backups. My problem is, I want my transaction log backups to run hourly but not at the same time not when the full or differential backups are running...Anyone know a way around this? Would the priority and availability section of the backup be a good way of handing this?
0
jhakie
Asked:
jhakie
  • 2
1 Solution
 
SandeepratanCommented:
what are the times you have scheduled the full and differential backups, in my case i have full backup every day once, diff backup every hour and log backups every 2 hours

example
        diff backup at 1 PM
                                             log backup at 1.30
next diff backup at 2 PM                            
next diff backup at 3 PM
                                            log backup at 3.30

etc...



0
 
jhakieAuthor Commented:
Full (M, W, F) - DIFF(T, TH, S) Transaction Logs 4 hours...I was hoping there was a way to link the jobs kind of the way you can with duplicate backup sets.
0
 
Alpesh PatelAssistant ConsultantCommented:
You can schedule the back up using SQL Job.
0
 
jhakieAuthor Commented:
We have decided to run these jobs using SQL and the I will pickup the BAK files using BackupExec for tape backups.
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now