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
