Re: schedule of SQL LOG backup
2004-09-22 02:58:25
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.
|
|
|