dbTalk Databases Forums  

Event ID 17055 (18052 Error:826)

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


Discuss Event ID 17055 (18052 Error:826) in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #121  
Old   
Jeffrey Williams
 
Posts: n/a

Default Re: Event ID 17055 (18052 Error:826) - 07-31-2008 , 12:14 PM






Paul Essick wrote:
Quote:
Lost power on the active node of my SQL Server. It failed over to Node 2
without problem, but when I brought it back to Node 1 (the server that lost
power) I get Event ID 17055
Error Description 18052
Error 826
Severity 22

The MSSQLServer service trys to start and then stops. I can't find anything
on this specific error.

Thanks,
Paul
Review the document at

http://www.eventid.net/display.asp?e...Server&phase=1

Towards the middle of the page, I found this:

Error: 18052 - Startup of MSSQLServer fails with this listed in Event
Viewer and no real additional information. I found that a second startup
parameter for the master_log_path was added pointing to an invalid file,
conflicting with the default (mastlog.ldf). The only resolution was via
Regedit -> HKLM\Software\Microsoft\MSSQLServer\Parameters\SQL Arg#.
Look for a duplicate -l pointing to anything but the mastlog.ldf and
remove it. This may cause some errors on the master_file_path and
error_log_path; situation that I have not tested.

Don't know if this applies, but worth a shot.

Jeff


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.