The worst thing I found out today is that a reindex job for a couple of tables(high volume) in 2000 fills around 5 GB of transaction log entries but the same job running in 7.0 server with the same database and tables, fills only a few MB in the transaction log. I used Log explorer and found out that in 2000 he makes lot of log entries like Format page, modify rows etc,.
No user connections during the testing phase.
Can anyone explain this...