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