dbTalk Databases Forums  

Production SQL server down!!!

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Production SQL server down!!! in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Adam Freden
 
Posts: n/a

Default Production SQL server down!!! - 08-17-2004 , 02:24 PM






Someone attempted to change the partition layout of our SQL cluster, then we
recieved an error:

"Could not start the MSSQLSERVER service on local computer. The service did
not return an error. This could be an internal Windows error or an internal
service error. . . ."

in event log, we have two repetitive errors (application), and errors in
system log:
Application:
Event ID #17052
Error: 17826, Severity: 18, State: 1
Could not set up Net-Library 'SSNETLIB'.

and
Event ID#17055
17120 :
SQL Server could not spawn FRunCM thread.


System:
Event ID#1069
Cluster resource 'SQL Server' failed.

Any ideas? I've been "googling" all morning



Reply With Quote
  #2  
Old   
Rand Boyd [MSFT]
 
Posts: n/a

Default RE: Production SQL server down!!! - 08-18-2004 , 10:53 AM






Another point to consider:

If it turns out that the Parameters key is empty (and based on the
description of what happened, I believe this is it) then verirfy that the
following key exists:

HKLM\Cluster\Resources\{GUID for Resource}\RegSync.

If not, then this key will have to be recreated and the checkpoint files
for SQL Server may need to be recreated. You will probably want to open a
case with Microsoft Product Support Services (PSS) to help recreate the
checkpoint files.

Rand
This posting is provided "as is" with no warranties and confers no rights.


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.