thanks Mark ..
I thought of doing Full backup every 8 hours and LOG backup every 20
minutes ...
Is there a best pratice for SQL backup ??
thanks again
Luc
"Stapleton, Mark" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
2004-09-21 04:20 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
>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 ([EMAIL PROTECTED])
Berbee Information Networks
Office 262.521.5627
