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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Luc Beaudoin
Sent: Tuesday 21 September 2004 22:33
To: ADSM-L AT VM.MARIST DOT EDU
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" <mark.stapleton AT BERBEE DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
2004-09-21 04:28 PM
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Re: schedule of SQL LOG backup


From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] 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 (stapleton AT berbee DOT com)
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.