pbanghart
ADSM.ORG Member
G'day...
My SQL gurus are asking me to schedule their TDP backups from the central scheduler...I can do the once-a-day full backup schedules no problem, but they also want to do hourly transaction log backups from 5am to 7pm, Mon-Fri only.
I thought I could set up a script to run daily that would define a schedule with a start time of 5:00am, but the schedule expiration is by date, not by time, so I can get the schedule to stop at 7:00pm as desired.
Has anyone out there already done something like this?
-PB
My SQL gurus are asking me to schedule their TDP backups from the central scheduler...I can do the once-a-day full backup schedules no problem, but they also want to do hourly transaction log backups from 5am to 7pm, Mon-Fri only.
I thought I could set up a script to run daily that would define a schedule with a start time of 5:00am, but the schedule expiration is by date, not by time, so I can get the schedule to stop at 7:00pm as desired.
Has anyone out there already done something like this?
-PB