sqladmin 45377 (11/7/2012)
So I shouldn't see any more of these very large translog files unless/until I run another reindex job?
Reindexing should be one of your regular maintenance tasks
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?
No.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability