Job dependencies - Veritas Backup Exec

This is a discussion on Job dependencies - Veritas Backup Exec ; I need to force a Transaction Log backup to occur only after the normal SQL database backup occurs. Since I have 2 drives, the T-log backup frequently occurs during or prior to the database backup. Any ideas how I can ...

+ Reply to Thread
Results 1 to 2 of 2

Thread: Job dependencies

  1. Job dependencies


    I need to force a Transaction Log backup to occur only after the normal SQL
    database backup occurs. Since I have 2 drives, the T-log backup frequently
    occurs during or prior to the database backup. Any ideas how I can make the
    T-log backup dependent on the full backup? Running 8.5 on Windows 2000.
    Thanks,
    Andrew

  2. Re: Job dependencies

    1) schedule both jobs to run on the same drive

    2) use the command line interface to start the log job as a post job to the
    standard sql job. (i'd still point the jobs at the same drive to guarantee that
    the both backups are on the same tape.

    Andrew Frisbie wrote:

    > I need to force a Transaction Log backup to occur only after the normal SQL
    > database backup occurs. Since I have 2 drives, the T-log backup frequently
    > occurs during or prior to the database backup. Any ideas how I can make the
    > T-log backup dependent on the full backup? Running 8.5 on Windows 2000.
    > Thanks,
    > Andrew



+ Reply to Thread