How do I stagger SQL backups

droach

ADSM.ORG Senior Member
Joined
Jan 7, 2008
Messages
239
Reaction score
13
Points
0
Location
Cut and Shoot, Texas
PREDATAR Control23

Our DBA's are switching from using VBS scripts that TSM schedulers kick off to backup their databases to using the GUI in the v6.4 TDP/Flashcopy client schedule their backups. The VBS scripts ran through the installed list of databases in a serial fashion. Now, we are trying to figure out the best way to setup backups from the GUI and have them run in the same serial fashion. Staggering by offsetting the start time for each job is not reliable and inefficient. Anyone have any better suggestions?
 
PREDATAR Control23

Sounds like your previous way worked better, why are you switching?
 
PREDATAR Control23

The scripts have worked ok for the past 8 years, but they do have issues. The new DBA team is unable to support the scripts and I am not willing to do it for them.
 
Top