you need to setup a trace file. Then you can analyze information from past transactions.

Thanks for your reply Nils, I now realized that truncate is actually logged.

Quoting from: http://www.sqlservercentral.com/articles/delete/61387/

TRUNCATE logs the deallocation of the data pages in which the data exists. TRUNCATE...

I think the question had multiple correct replies.

I answer:

Delete is logged, truncate is not logged.

Truncate resets the identity for a table, delete does not.

Which I believe is also...

Thanks David, but my question was different:

If I need to add mirroring on a production system which at the time consists

of a single server (db01), do I have to block...

Thanks for the article. A quick question:

on a production system, can I do the backup/restore steps without

blocking incoming connections? If this is true, then the transactions

issued after the backup,...

Athens, Greece