• Yes, there is a very large translog file (2.1GB) in the TRN backup folder, followed by others no larger than 35MB. So I shouldn't see any more of these very large translog files unless/until I run another reindex job?

    reindex is often the cause of the largest tran log backup, check the time of this backup relative to you reindex job to confirm this. If its not giving you space issues don't worry about it, its normal behaviour.

    If I decide to run a DBCC DBREINDEX job in the future (from inside Query Analyzer I assume?) do I have to put the DB in Single User mode before I do so?

    as Gail said, no, but it is an intrusive process that will block user queries so be careful when you run it, best to leave it to your out of hours maintenance plan.

    ....and you dont need to buy any tools for any of this stuff

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