Schedule Backup Exec 2010 SQL Transaction Log Backups

Posted on 2011-04-21
Last Modified: 2012-05-11
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?
Question by:jhakie
    LVL 2

    Expert Comment

    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

            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


    LVL 1

    Author Comment

    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.
    LVL 21

    Accepted Solution

    You can schedule the back up using SQL Job.
    LVL 1

    Author Closing Comment

    We have decided to run these jobs using SQL and the I will pickup the BAK files using BackupExec for tape backups.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    VM backups can be lost due to a number of reasons: accidental backup deletion, backup file corruption, disk failure, lost or stolen hardware, malicious attack, or due to some other undesired and unpredicted event. Thus, having more than one copy of …
    VM backup deduplication is a method of reducing the amount of storage space needed to save VM backups. In most organizations, VMs contain many duplicate copies of data, such as VMs deployed from the same template, VMs with the same OS, or VMs that h…
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
    The viewer will learn how to download and install Comodo Backup on Windows 7. Comodo Backup is another solution for backing up your computer. It is free for local backup and online backup has differing amounts depending on storage required. In my op…

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now