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