We build cube on one server and then I want to archive the database
where it was built onto a File share on another server and then run a
restore on the other server.

Please kindly share a script if you have any that can archive the
database on one server and restore on another.

I am planning to incorporate this into a DTS package

Thanks
Karen

For AS2k You can always use the DSO/XML script at:
http://www.microsoft.com/downloads/d...DisplayLang=en

Note, for Yukon, SQL Management Studio can generate an XMLA file that can be
used to generate the OLAP database. Note, that these scripts perform an
archive and restore of the entire Olap database, not just an Olap cube.

--
HTH!
Denny Lee
<dennyglee_at_hotmail_dot_com>

Blog at:: http://spaces.msn.com/members/denster/



<karenmiddleol (AT) yahoo (DOT) com> wrote

The msmdarch utility works against databases; not cubes -- thus you archive
databases; not cubes. For a detailed discussion of this topic, look at the
AS Operations Guide white paper at:
http://www.microsoft.com/technet/pro.../anservog.mspx
under the topic "Release Management".
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


<karenmiddleol (AT) yahoo (DOT) com> wrote