MyDoggieJessie (2/14/2013)

---

midnight251 (2/14/2013)

---

Great info thanks. What would a sensible size be, 50 gig? I did notice a 'Shrink File' in the Maintenance Plan, is this what I use for the one time shrink? What happens if I try to shrink the file past what the size actually is? Sorry for all the questions, but, we're almost home.....

A good rule to follow for sizing your transaction log file would be to find out what your largest clustered index size is for that particular instance, and size your file to that size (preferably a little more). That way when your indexing strategy kicks off, you hopefully won't have to grow your log file while your larger indexes are being rebuilt.