From: "Robert Comer" 

That's good to know.

- Bob Comer


"Ellen K."  wrote in message
news:8gd61v4u8ahtv2u7qlmfp7akkjg8a37erd{at}4ax.com...
> SQL Server has three levels of logging.
>
> On Mon, 30 Dec 2002 08:57:03 -0500, "Robert Comer"
>  wrote in message :
>
> >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