Hi,

perhaps this question might have allready been posted here, but i need help
in SQL Server 2000:

how do u backup all the cubes, objects, dimensions, members, aggregations
and meta data. or better say everything u can see in Analysis Manager (the
whole database) so u can just copy it to another server and use it there
independently of the source Analysis manager server?

thanx in advance...

Hi

I use the msmdarch utility to create a .cab file.

I have a cmd file using this syntax

"C:\Program Files\Microsoft Analysis Services\Bin\msmdarch" /a <Servername>
"C:\Program Files\Microsoft Analysis Services\Data\" "<DBName>"
"C:\path\file.cab"

in my case:

"C:\Program Files\Microsoft Analysis Services\Bin\msmdarch" /a BISERVER01
"C:\Program Files\Microsoft Analysis Services\Data\" "Analysis"
"C:\bi\CubeBackup\Analysis.cab"

You can schedule this .cmd file with windows scheduler to have the backup
run automatically say once per day.

-Henrik.

"marko" <hybrid_1701 (AT) hotmail (DOT) com> skrev i en meddelelse
news:%23qARXFRJHHA.3952 (AT) TK2MSFTNGP02 (DOT) phx.gbl...

Hi

I use the msmdarch utility to create a .cab file.

I have a cmd file using this syntax

"C:\Program Files\Microsoft Analysis Services\Bin\msmdarch" /a <Servername>
"C:\Program Files\Microsoft Analysis Services\Data\" "<DBName>"
"C:\path\file.cab"

in my case:

"C:\Program Files\Microsoft Analysis Services\Bin\msmdarch" /a BISERVER01
"C:\Program Files\Microsoft Analysis Services\Data\" "Analysis"
"C:\bi\CubeBackup\Analysis.cab"

You can schedule this .cmd file with windows scheduler to have the backup
run automatically say once per day.

-Henrik.

"marko" <hybrid_1701 (AT) hotmail (DOT) com> skrev i en meddelelse
news:%23qARXFRJHHA.3952 (AT) TK2MSFTNGP02 (DOT) phx.gbl...

That will work as long as your OLAP database isn't larger than 2GB (i
believe).

If it is, you have to backup both the data folder and metadata database.
These are the only two things you will need to backup.

You will have to make sure they are both in sync. When we back up we take
the OLAP service down to ensure they remain in sync.


"Henrik Hansen" <hjoellund (AT) mail (DOT) tele.dk> wrote

Thank You for Your answers!

I was just checking if i was on the right path. .

Please Jesse if u can explain this with backing up databases larger than 2
Gb? What exactly must be done except stoping OLAP? Is it just to stop OLAP
and then do msmdarch or something else needs to be done?

Thank you once again for your quick replys. Was able to back up my cubes.

marko




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

actually i blogged about it here:

http://jesseorosz.spaces.live.com/


"marko" <hybrid_1701 (AT) hotmail (DOT) com> wrote

thanx again for your answers!

merry christmas and a happy new year!


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