• all shrink events appear in the default trace and you can see them listed under database - right click - reports - standard reports - disk usage.

    Reindex jobs are the most frequent causes of large tran log usage.

    ---------------------------------------------------------------------