Monday, February 20, 2012

'Online Pending' status in cluster

Hello,
I have SQL Server 2k Enterprise Edition, sp3 installed on a cluster.
When SQL Server first installs, everything looks fine in the cluster
administrator. However after about 30 minutes or so the status of
MSSQLServer, SQL Server Agent and SQL Server Full Text services goes
from 'Online' to 'Online Pending'. The service looks to be stopped when
I am in Enterprise Manager but I can still get in and look around the
databases - but only for a short time. After another 30 minutes or so,
the status of the services in the cluster administrator goes from
'Online Pending' to 'Failed' and there's no error messages to give me
any clues. Any help would be wonderful!
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!Is there anything in any of the event logs, specifically the application and
the system logs?
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Rachael" <rachael_faber@.hotmail.com> wrote in message
news:OZ25H9ZFEHA.3548@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I have SQL Server 2k Enterprise Edition, sp3 installed on a cluster.
> When SQL Server first installs, everything looks fine in the cluster
> administrator. However after about 30 minutes or so the status of
> MSSQLServer, SQL Server Agent and SQL Server Full Text services goes
> from 'Online' to 'Online Pending'. The service looks to be stopped when
> I am in Enterprise Manager but I can still get in and look around the
> databases - but only for a short time. After another 30 minutes or so,
> the status of the services in the cluster administrator goes from
> 'Online Pending' to 'Failed' and there's no error messages to give me
> any clues. Any help would be wonderful!
>
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!

No comments:

Post a Comment