MSSQLSERVICE Stopped Due to abnormal shutdown | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

MSSQLSERVICE Stopped Due to abnormal shutdown

MSSQLSERVICE Stopped Due to abnormal shutdown.
?Have any solution to recover without reinstall the SS 2000
be more descriptive about the problem. Tell us when it occured, what is the error in log, what action have u taken, and what is the system specification, what is the backup Strategy Madhu
Did you try to restart after abnormal shutdown?
How do you know it is abnormal shutdown without checking logs? MohammedU.
Moderator
SQL-Server-Performance.com
I would second Madhu’s question in this case as there might be hardware issues or any virus or software corruption to causee this abnormal shutdown. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
Due to electric fluctuation system was abnormal shut down &
when start the system then SQLSERVER not started and msg found
"could not start the MSSQLSERVer service on local computer" I found this problem several times .
I recovered this after reinstall the sql server. I want that how fix this problem without reinstalltion . Thanks for reply
Check SQL Server Error Log…. for master file corruption… Check whether is there antry Syste Cannot find the File SPecified Occured WHile opening ‘Your Installation pathMaster.mdf” in that case u will have to rebuild u r master db http://msdn2.microsoft.com/en-us/library/aa213831(SQL.80).aspx and also google for "rebuild master database" Madhu
Due to electric fluctuation system was abnormal shut down &
when start the system then SQLSERVER not started and msg found
"could not start the MSSQLSERVer service on local computer" This is nothing but you are risking your application due to intermttent power loss to the server, why not keep them in a stable power condition by keeping the UPS. Better to take action before it goes totally down. This is not the problem of recovering database, better you resolve the power issue. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
Along with UPS you should have battery-backed disk controllers… Power failure in the middle of writing a page can cuase "torn page".
If you have HW write caching with battery-backed disk controller caches can ensure that data is
successfully written to disk or not written at all. battery-backed means…Separate and localized battery backup facility directly available and controlled
by the caching mechanism to prevent data loss.
Note This is not an uninterruptible power supply (UPS).
A UPS does not guarantee any write activities
and can be disconnected from the caching device. http://support.microsoft.com/kb/230785
MohammedU.
Moderator
SQL-Server-Performance.com
]]>