We are planning to defragment out transaction log files following the advice of Kimberley Tripp (http://www.sqlskills.com/blogs/kimberly/transaction-log-vlfs-too-many-or-too-few/
) and are to get a grasp on how long of downtime to plan. We have not done this before and would like to get some advice from others who have.
Since we are first backing up the transaction log and doing a shrinkfile, I expect the 100 Gig transaction log will have minimal data and we will encounter minimal downtime... and can plan a maintenance window of 30 minutes.
If you have experience defragmenting your transaction log files, how big is your transaction log and how long did it take for you?