dbTalk Databases Forums  

Analysis Services Database & OLAP Service Problems

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Analysis Services Database & OLAP Service Problems in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Pete K.
 
Posts: n/a

Default Analysis Services Database & OLAP Service Problems - 06-16-2004 , 02:04 PM






We had a disk crash on our server a few days ago, which was where the
Analysis Services database files were stored - the disk was replaced
and the contents restored from the drive backup. I'm now having
trouble getting back online with my OLAP database.

When I get into Analysis Manager, I am not able to do anything with
the OLAP database - I can see the database okay, but Analysis Manager
freezes everytime I click on the database name, overwrite the database
with a restore of an archive, or delete the database all together.

I have tried manually stopping & starting the OLAP service (through
the Control Panel / Services window) - the service stops okay, but
gets stuck in the "Starting" status when I try and start it. The
service did start okay after a reboot last night, but I have the same
problems mentioned above whenever I try to do anything with the
database. And the service once again gets stuck in the "Starting"
status when I try to manually stop/start it.

Thanks in advance for any help on this issue.

Pete

Reply With Quote
  #2  
Old   
Pete K.
 
Posts: n/a

Default Re: Analysis Services Database & OLAP Service Problems - 06-17-2004 , 12:30 AM






Sorry for the double post on this issue

I did resolve the issue I was having - turns out I had a corrupt
database. I found the following MS article
http://support.microsoft.com/default...b;en-us;278325 that
talks about OLAP server issues when trying to deal with a corrupted
database. THe suggested workaround did not solve the problem - I
ended up changing the Analysis Server data drive, then stopped/started
the server successfully, as it was able to bypass the corrupted
database.

Pete

pfk92000 (AT) yahoo (DOT) com (Pete K.) wrote in message news:<63924075.0406160948.69649f6 (AT) posting (DOT) google.com>...
Quote:
We had a disk crash on our server a few days ago, which was where the
Analysis Services database files were stored - the disk was replaced
and the contents restored from the drive backup. I'm now having
trouble getting back online with my OLAP database.

When I get into Analysis Manager, I am not able to do anything with
the OLAP database - I can see the database okay, but Analysis Manager
freezes everytime I click on the database name, overwrite the database
with a restore of an archive, or delete the database all together.

I have tried manually stopping & starting the OLAP service (through
the Control Panel / Services window) - the service stops okay, but
gets stuck in the "Starting" status when I try and start it. The
service did start okay after a reboot last night, but I have the same
problems mentioned above whenever I try to do anything with the
database. And the service once again gets stuck in the "Starting"
status when I try to manually stop/start it.

Thanks in advance for any help on this issue.

Pete

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.