Here is my senario:
8:30 add a bunch of rows to a table
9:00 start full backup
9:05 finish full backup
9:20 truncate table
9:30 try to restore the database to get the table rows back
"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message
> Except that (as someone has already told you), you can only perform a
> recovery to a point in time AFTER your initial backup has completed.
>
> So if the timeline was:
>
> 10.00am start backup
> 10.05am finish backup
> 10.07am truncate table
>
> Then you can't do an incomplete recovery to 10.04am, but you could do one to
> 10.06am, and you'd get your table data back that way.
>
> Remember that in real life this isn't much of an issue, because backing up
> is a continuous process (I mean, you backup on Monday, and Tuesday and
> Wednesday and Thursday, not that the backup just runs and runs for ever!).
> Which means that practically, you can choose just about any time for an
> incomplete recovery. You are only seeing this 'anomaly' because you only
> have the one backup to hand.
>
> Regards
> HJR
Received on Thu Jan 30 2003 - 10:26:28 CST
