Thanks a lot for all the responses. Yes the databases are smaller than 512 GB.

How easy was it for you to do the export and import? How big was the database/s? Was is a very time consuming and tedious?

Trying to estimate the time and...

Thanks! I figured it out. Its working great!!

Vidhya.

Shekhar,

Thanks for the script. I modified it at my end and am trying to run it and I only get a blank box pop up. It is not sending mail....

Carlton,

Can you educate me on the Resource governor in 2008. Maybe upgrading is an option 🙂

Vidhya.

Thanks a lot for the suggestions. The server only has SQL on it. The reason for thinking about scaling out or load balancing was because there are a lot of...