June 5, 2008 at 10:37 pm
I have take full backup on sundays and log backup by everyday,
Log backup file overrided. ie i keep one full back up for sun day and only one log backup for saturday
is it possible to restore point in time restoration
Sundy -- Full backup(i keep the file in my Tape)
monday - Log backup
Tuseday -- Log backup ( this file override the monday file)
wednesday -Log backup ( this file override the Tuesday file)
.
.
Saturday--Log backup(I keep the file in my tape)
is it possible to restore point in time restoration???
June 5, 2008 at 10:51 pm
You have to have every log file since your last full backup unless you do a differential. Then you have to have every log file since your last differential. Do not overwrite the log files until you get a full backup again or the log file will be useless.
June 6, 2008 at 4:42 am
As ken said you need to keep all log backups from thelast full/diff backup. If your T/Log backup overwrites the previous the T/Log backup then you will not be able to restore to a point intime.
Gethyn Elliswww.gethynellis.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply