We set the full backups at xx:00, then the logs on the half hour, so far with success.
---- Original message ---- >Date: Mon, 9 Jan 2006 09:15:08 -0500 >From: Zoltan Forray/AC/VCU <[EMAIL PROTECTED]> >Subject: [ADSM-L] SQL Logs and Backup conflict >To: [email protected] > >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 ? Fred Johanson
