From: "Robert Comer" 

I don't know about MSSQL, but on the AS/400 it's an option as to what is
kept. (or if it's kept at all)

- Bob Comer


"Mike Nice"  wrote in message
news:p2h01v8m0a3idtgd4ksvr529oqoffggqf9{at}4ax.com...
> On Sun, 29 Dec 2002 12:38:36 -0500, "Geo."
 wrote:
>
> >Ok now you are going to have to explain. The way I understand it the log
> >file is nothing but a log of all transactions, it is not a copy of
deleted
> >data, the actual deleted data is simply marked as deleted and still in
the
> >database until you do a shrink at which time it's really deleted in order
to
> >shrink the database. So even if you don't change the log file at all but
you
> >do shrink the database there is now no way to restore that deleted data
> >except from backup medium.
>
>    The transaction log must contain a copy of all previous data; otherwise
how can it be used to
> apply changes as well as deletes - it must contain a copy of the data
before the change.

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