You understand the situation correctly.

We will give the transaction log suggestion a try. That should work pretty well.

Thanks for your response.

I'll have to check out Operations Manager. It appears there is a lot you can do with Powershell, and I wasn't sure what other people on this site were...

I have tried to avoid the SN scene mainly because I know it takes a lot of time (as many of you have confirmed) to keep up with everything. ...

When you setup a data mart, do you create the data mart outside the data warehouse as a separate database or is it created inside the dimensional data warehouse?

Thanks for your response.

It's starting to make more sense now.

Thanks for the reply. I'll see what I can do about the 64 bit version as well.