dbTalk Databases Forums  

OLAP Service Stuck in "Starting" Status

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


Discuss OLAP Service Stuck in "Starting" Status in the microsoft.public.sqlserver.olap forum.



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

Default OLAP Service Stuck in "Starting" Status - 06-16-2004 , 02:02 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
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.