Currently in our production environment we have no archiving or backing up
of our Analysis Services databases. I'm currently putting together a plan on
how to do so.

Some questions:

-We'll have very large cubes, possibility into the TB's.What's a smart
strategy in backing up a large AS database? We'd like to do this at least
once a day, maybe twice.
-How can I backup just the schema? (just the "shell", so all I'd have to do
is reprocess the cube) Anyway to automate this?

Thanks!

Hi Jesse,
There is a whitepaper that discusses this located at
http://www.microsoft.com/technet/pro.../anservog.mspx

There is another tool called the Metadata Scripter that comes with the SQL
Server 2000 resource kit, this will script the Cube to a VBScript and then
you can rerun the script to reload the just definition of the cube.

Always be sure to backup the repository no matter what!!! If your
repostitory is corrupt and you don't have a backup, then you are really
sunk.

David Botzenhart


"Jesse O" <jesperzz (AT) hotmail (DOT) com> wrote