Thank you for everyone's input. Y'all are very helpful.

Thanks. I am researching "Kimberly Tripp VLF" now. Yes our growth is defaulted to 10% growth and I do not see a scheduled disk defrag process in place.

I will track...

This is interesting. Currently, our Diff runs every Wednesday and Full every Sunday.

Base on our current scenario, what is the formula for how long we should keep our log...

Thank you so much. I've over looked the point-in-time restore ability. We are currently performing transaction log backups every 15 minutes. I wonder if we are over looking other best...

Hey Luis,

Thanks for taking the time to reply. Let me see if I can better define what I am looking for.

Currently, our forms are stored in many tables with...

Luis,

I want to thank you for taking the time to read my post. Let me address your questions.

Are you seriously taking the advice and code from someone from the internet...

So what is the approach? Keep working with the 8 servers and just add more memory (RAM and HDD) when needed?

We have over 100 databases across these servers. I am...