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)
Mark Stapleton (stapleton AT berbee DOT com)
Berbee Information Networks
Office 262.521.5627