I currently run SQL Server and Analysis Services on one server to
rebuild my datawarehouse and OLAP environment. Once that is finished
(nightly) I'd like to move the Analysis Services database to another
server for read-only access. I know how to archive and restore AS
databases, but is there a way to automate that process? If so, is
there documentation on that?

DJC wrote:

We offer a tool that can do it for you.
http://www.solgenia.com/usa/Solution...SheetRubik.htm

If you look in BOL, can you also call the Archive and Restore utilities from
the command line. Thus you could easily schedule it with SQL Agent.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"DJC" <danc (AT) ppmcinc (DOT) com> wrote

That is exactly what I do. I have a bat file that allows me to provide the
source server and catalog, and then the targer server for the restore. The
bat file archives the cube and then restores to the target server. Note that
the SQL Agent process must be ran under a user that is authorized for write
access on the target server. Also I have ran into a intermittent issue where
the restore fail and the log indicates the file already exists. When this
happens the cube that existed on the target server is deleted. If anyone know
why this happens, it would be great to get it resolved

Racter

"Dave Wickert [MSFT]" wrote: