ADSM-L

Re: schedule of SQL LOG backup

2004-09-21 16:20:58
Subject: Re: schedule of SQL LOG backup
From: "Stapleton, Mark" <mark.stapleton AT BERBEE DOT COM>
Date: Tue, 21 Sep 2004 15:20:58 -0500
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On 
Behalf Of Luc Beaudoin
>Is there a way to make a schedule to take the backup of the 
>SQL LOG every 20 minutes ..

Now think about that for a minute; that's three log backups per hour. If
you have to restore the database 20 hours after the full backup is done,
that means there are 61 files you have to restore, most likely from
tape. That will make for a unnecessarily long restore.

Do you really need *that* fine a granularity?

--
Mark Stapleton (stapleton AT berbee DOT com)
Mark Stapleton (stapleton AT berbee DOT com)
Berbee Information Networks
Office 262.521.5627  
<Prev in Thread] Current Thread [Next in Thread>