-
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
-
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:
[color=blue]
> 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[/color]