Can you not just increase the size of the backup window on the hourly
backups?

They will just wait behind the daily backup and run when it finishes.  They
won't show as missed because they ran, eventually, within their window?
When there is no comflict, they will run as soon as they normally would,
assuming schedmode=prompted.

Regards

Steve

Steve Harris
AIX and TSM Admin
Brisbane Australia

> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]
> On Behalf Of Zoltan Forray/AC/VCU
> Sent: Wednesday, 11 January 2006 6:57 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: [ADSM-L] SQL Logs and Backup conflict
>
>
> Same node name for both.  Multiple different schedules (for
> logs, diff-backups, os-backups, etc).
>
>
>
> Sung Y Lee <sunglee AT US.IBM DOT COM>
> Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> 01/10/2006 03:43 PM Please respond to
> "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
>
>
> To
> ADSM-L AT VM.MARIST DOT EDU
> cc
>
> Subject
> Re: [ADSM-L] SQL Logs and Backup conflict
>
>
>
>
>
>
> clarification question.
>
> are you using a same node name for both TDP agent and regular
> client? Or you are not using any TDP and straight forward
> regular node name?
>
> Sung Y. Lee
>
> "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on
> 01/09/2006 09:15:08 AM:
>
> > We are looking for a creative solution (or answer) to a long
> > outstanding "issue" when it comes to SQL TDP backups.
> >
> > We have a major M$-SQL shared server.
> >
> > There is an HOURLY schedule to dump the transaction logs.
> >
> > When the daily backups kick off, the hourly transaction log backups
> > then proceed to fail, causing constant annoying "schedule
> has failed"
> messages,
> > until the DB backups finish.
> >
> > How do other folks handle this kind of conflict ?  Are we
> missing some
> TDP
> > backup option ?
> >
> > My prefered solution would be to have TSM scheduling be
> more flexible,
> > e.g. only run this schedule between 10am and 10pm.
> >
> > Your thoughts ?
>
>
>