Re: schedule of SQL LOG backup
2004-09-21 16:32:58
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
|
|
|