Hi All -
using SQL 2000, i executed some DML (create Tables)/DDL (insert records) statements on Database & noticed the very strange behavior of Transaction log.
Lastly it observed the number of rows in Transaction log is 2958
And now the total number of rows in Transaction log is 458

It seems that transaction log is truncated.

I did following steps >>
1) Created DB from the Enterprise Manager & here is the default options details:

Recovery
      Model - Full
Setting
      Auto update statistics - True
      Auto Create Statics - True
      Torn page detection - True
     Other options are false like Auto shrink...auto close....
2) Created some Tables in DB
3) Inserted records into these tables.
4) Checked number of records in a Transaction log by using DBCC Log ('DB_Name', 4) - previously it was 2958
5) Inserted more records into tables.
6) Checked number of records in a Transaction log & it is 458

I’m confused with this strange behavior of SQL Server, can anyone please suggest me how can I stop this truncation or capture this event.

N.B: I observed the same behavior in SQL 2005 too.

---

Thanks,
Baddy

Are you sure that a transaction log backup didn't occur during your process?

yes, i'm not taking any baackup.
just using DB as backend for my application.
even i'm unable to read previous days Transaction log.

---

Thanks,
Baddy