From: "Geo." 

"Mike Nice"  wrote in message
news:ng331v881rsan1f4r27l61pkrhbitfpto8{at}4ax.com...

>       I'm not an expert, but you're referring to journaling which when
replayed against a restore of
> the original database can recreate the DB up to the point of the last log
backup.
>
>     The transaction log serves another function: if in the entire
transaction cannot be completed,
> it can be rolled back as if it never existed.  An UPDATE X SET Y=Y+1
creates a huge entry in the
> transaction log.

I understand the log can be used to roll forward or backwards. My
contention is that once you do a database shrink you can no longer roll
back record deletions.

Geo.

--- BBBS/NT v4.01 Flag-4