Hello Luc, I think the only way to do this from the TSM scheduler is to define three schedules, one with a start time of 00:00, one at 00:20 and one at 00:40. Then set the periodicity to one hour for each of the three schedules.
Cheers, Paul. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Luc Beaudoin Sent: Tuesday 21 September 2004 22:33 To: [EMAIL PROTECTED] Subject: Re: schedule of SQL LOG backup Hi Mark ... So with that setup ... worst case ... they will loose 4 hours of work ??? I'm working in a hospital ... so even 1 hours lost of lab result or patient appointment can be kind of hell anyway .. if there is no way of putting minutes ... I will put the minimum ... 1 hours ... thanks a lot Mark Luc "Stapleton, Mark" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 2004-09-21 04:28 PM Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject: Re: schedule of SQL LOG backup From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Luc Beaudoin >I thought of doing Full backup every 8 hours and LOG backup >every 20 minutes ... >Is there a best pratice for SQL backup ?? What works best is whatever meets your business needs. Most of my customers do a full backup of databases once a day, and periodic log backups (every 4 hours, for example) throughout the day. YMMV. -- Mark Stapleton ([EMAIL PROTECTED]) Berbee Information Networks Office 262.521.5627 Any e-mail message from the European Central Bank (ECB) is sent in good faith but shall neither be binding nor construed as constituting a commitment by the ECB except where provided for in a written agreement. This e-mail is intended only for the use of the recipient(s) named above. Any unauthorised disclosure, use or dissemination, either in whole or in part, is prohibited. If you have received this e-mail in error, please notify the sender immediately via e-mail and delete this e-mail from your system.
