I'm trying to find some info on how to restore analysis services to another
server. Cubes, security, the whole thing.

Can anyone suggest a good link \ resource.
--
burt_king (AT) yahoo (DOT) com

Books on-line is the best resource. I just did a simple search for "backup"
restricting the technology to Analysis Services and got a very complete
discussion.

If you are looking to automate the process, then look install the SQL
Samples and look in the folder:
C:\Program Files\Microsoft SQL Server\90\Samples\Analysis
Services\Programmability\AMO\BackupAndRestore

--
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.


"burt_king" <burt_king (AT) yahoo (DOT) com> wrote

Mine didn't even come up with a "How to....."


--
burt_king (AT) yahoo (DOT) com


"Dave Wickert [MSFT]" wrote:

Dave is talking about Analysis Services 2005.

If you are referring to the 2000 version then archiving and restoring
the database from one server to the other should work fine as long as
the 2 servers are in the same domain.

Right click on the database in Analysis Manager on the source server and
choose the "Archive Database..." option. Then right click on the server
node on the destination server and choose "Restore Database..."

If you are talking about a disaster recover scenario then there are 2
items that need to be restored.

1. All the files in the data folder, by default this is stored at:
C:\Program Files\Microsoft Analysis Services
but this location can be configured from Analysis Manager.


2. The repository. By default, this is located in a file called:
C:\Program Files\Microsoft Analysis Services\Bin\msmdrep.mdb

But it can also be stored in a SQL database if you chose the option
to migrate your repository (or if you are running a 64bit edition)
In the case of the SQL based repository, the standard operations for
backing up and restoring a SQL Database apply.

HTH

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <F36AB34D-AD86-454F-9132-108040760A13 (AT) microsoft (DOT) com>,
burt_king (AT) yahoo (DOT) com says...

That's definately much better info but isn't it documented somewhere?
--
burt_king (AT) yahoo (DOT) com


"Darren Gosbell" wrote:

Have you looked at the AS Operations Guide? It talks about this issue.
http://www.microsoft.com/technet/pro.../anservog.mspx
--
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.


"burt_king" <burt_king (AT) yahoo (DOT) com> wrote

The Analysis Services Operations Guide has some information on this, I
think it's under the heading of configuration/release management, but it
is equally applicable in a disaster recovery scenario.

http://www.microsoft.com/technet/pro...ntain/anservog.
mspx

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <716DA978-5BB3-4829-B77E-64C1B9BA6B6C (AT) microsoft (DOT) com>,
burt_king (AT) yahoo (DOT) com says...