This information is extremely informative. Hopefully I'll know in the next couple of weeks if this is the direction the business is set on.

Many thanks!

Jeremy

Thanks for the information Steve. I'm still kinda new to the cube structure, so I'm probably way off on how the data is stored. My assumption was if...

I was able to restore the NorthWind db to a test database (on the same server) with no trouble and it did not affect the orginal Northwind db.  I used...

Pretty sure that is incorrect.  I will try and test it today and let you know.

J

In order to truly do a SQL hot backup you need the TDP SQL module that is a part of TSM.  My company uses it and is seems to work very...