I am given an immediate responsibility of administering
couple of Analysis servers in SQL 2K

Right now Analysis server is installed, the repository is
in Access database, and the customer has created cubes and
dimension.

What are all the stuff I have to do to Administer. I am
not involved in creatind cubes, or dimension are anything
etc...

1. Whether i need to archive (backup) the OLAP db
2. If so do i have to do it daily ?
3. Right now the cubes and files are backed directly to
tape since these files are not locked including the
repository mdb files...

4. What is the easiest way to restore OLAP db - from the
backup or the backup made by Tape...

Also what is the procedure to recover a corrupted OLAP db -
if something happens ?

I read BOL, but couldnt find out whether Archive of db is
necessary - Is there any startup whitepaper etc that tells
me what are the stuff i have to do...Please let me know

Thanks

SK

1) You certainly want one saved archive of (refreshed any time you make
structural changes).
2) Since all the cube data can be re-imported from rdbms (typically), it's
not a neccesity to do daily archives.

To restore corrupt DB (very rare, kudos to MS), restore the archive then
reprocess everything.

public @ the domain below
www.tomchester.net


"SK" <ksaravan (AT) hotmail (DOT) com> wrote

There's also a recently published whitepaper that should be helpful for you
as well.

Microsoft SQL Server 2000 Analysis Services Operations Guide

http://go.microsoft.com/fwlink/?linkid=22634


--
Sean

--
Sean Boon
SQL Server BI Product Unit

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

"Tom Chester" <publicNOSPAM (AT) tomchester (DOT) net> wrote

Sean,

Thanks for another informative MS Analysis Services paper. Am I correct
in assuming that OLAPScribe is the Word-based documentation tool that
you promised the group recently?

week or
early next week. There is a tool that will be available that will
document
the structure of an AS database in a Word document. An announcement
will be
made in this newsgroup when the tool is available for download.

--
Sean

--
Sean Boon
SQL Server BI Product Unit
...
You should also document all of the objects in Analysis Services. For
example, you can use OLAP Scribe, which is a Microsoft Word template
that allows you to generate complete documentation of Analysis Services
using Decision Support Objects (DSO). You can obtain this template at
http://go.microsoft.com/fwlink/?LinkId=22012.
...

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Yes. That is it. Looks like you found it already on the download center.
We were in the process of formulating an announcement to the newsgroup of
its availability.

Sean


--
Sean

--
Sean Boon
SQL Server BI Product Unit

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> wrote