Great article. Here's a question that I've been looking for an answer to. What do you use for a realistic size of a transaction log. We take t-log backups every 2 hours. On any given in-house database we generally size the t-log to be anywhere between 1/4 to 1/2 the size of the datafiles. On several out of house apps that rule won't apply. ie. we have an 8gig db that has a tlog of 192gig.

At what point do you go back to the vendor and tell them to manage the transactions and that a nominal size is less than or equal to the datafile size.

Just wondering.

Tom