SQL Server Performance Forum – Threads Archive

SQL Server shuts down automatically

Hi, My SQL Server shuts down automatically once in 3 days. SQL server was re-installed recently. After this re-installation, we have noticed this automatic shutdown. What could be the reason for this? Regrds
Riya
Riya

---

have you observe SQL ERROR LOG and EVENT VIEWER for any error !? seems strange , i dont feel any reason for shut down ! unless its infected with slammer , have you installed all recent patches and hot fix !
or please be more specific Regards Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami

---

Can you please help me with the latest required patches & hot fixes. We are using SQL Server 2000 Ent Edition. Riya Riya

---

Check microsoft site for all the latest service packs and hot fixes related with SQL server 2000.
You can download it from there.

---

Hi,
you can obtain it from download.microsoft.com as its too many i cannot name all
you can install lattest sp4 with its patch that fix awe problem.
Regards
Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami

---

Hi,<br />here you go:<br /><br />Security Bulletin :<br /><br /><a href=’http://www.microsoft.com/technet/security/current.aspx?productid=30&servicepackid=0&chkcritical=on&chkimportant=on&chkmoderate=on&chklow=on&seldaterange=0&txtdatestart=&txtdateend=&submit1=go’ target=’_blank’ title=’http://www.microsoft.com/technet/security/current.aspx?productid=30&servicepackid=0&chkcritical=on&chkimportant=on&chkmoderate=on&chklow=on&seldaterange=0&txtdatestart=&txtdateend=&submit1=go'<a target="_blank" href=http://www.microsoft.com/technet/security/current.aspx?productid=30&servicepackid=0&chkcritical=on&chkimportant=on&chkmoderate=on&chklow=on&seldaterange=0&txtdatestart=&txtdateend=&submit1=go>http://www.microsoft.com/technet/security/current.aspx?productid=30&servicepackid=0&chkcritical=on&chkimportant=on&chkmoderate=on&chklow=on&seldaterange=0&txtdatestart=&txtdateend=&submit1=go</a></a><br /><br />Subscribe Security Bulletin Message Service :<br /><br /><a href=’https://profile.microsoft.com/RegSysProfileCenter/subscriptionwizard.aspx?wizid=5a2a311b-5189-4c9b-9f1a-d5e913a26c2e&lcid=1033′ target=’_blank’ title=’https://profile.microsoft.com/RegSysProfileCenter/subscriptionwizard.aspx?wizid=5a2a311b-5189-4c9b-9f1a-d5e913a26c2e&lcid=1033′>https://profile.microsoft.com/RegSysProfileCenter/subscriptionwizard.aspx?wizid=5a2a311b-5189-4c9b-9f1a-d5e913a26c2e&lcid=1033</a><br /><br />Download SP4 :<br /><br /><a href=’http://www.microsoft.com/sql/downloads/2000/sp4.mspx’ target=’_blank’ title=’http://www.microsoft.com/sql/downloads/2000/sp4.mspx'<a target="_blank" href=http://www.microsoft.com/sql/downloads/2000/sp4.mspx>http://www.microsoft.com/sql/downloads/2000/sp4.mspx</a></a><br /><br />Facts on Database Security :<br /><br /><a href=’http://www.microsoft.com/sql/evaluation/compare/databasesecurity.mspx’ target=’_blank’ title=’http://www.microsoft.com/sql/evaluation/compare/databasesecurity.mspx'<a target="_blank" href=http://www.microsoft.com/sql/evaluation/compare/databasesecurity.mspx>http://www.microsoft.com/sql/evaluation/compare/databasesecurity.mspx</a></a><br /><br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />]<br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami<br />

---

http://www.sqlsecurity.com is a valuable source of information. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)

---

Totally strange !! I have never heard of this kinda SQL behaviour/bug. How about if someone has schedule a task to run ‘net stop’ for your SQL Server? Z:>net stop mssqlserver /y
The MSSQLSERVER service is stopping.
The MSSQLSERVER service was stopped successfully. Checking Server Events and SQL Error logs can help to find out the exact reasons. also check out who all have administrator rights for this SQL Server. BTW, is it a production server or you are talking about your local server? Deepak Kumar –An eye for an eye and everyone shall be blind

---

It is a production server. And I have checked for any such scheduler running. But found none. Regards Riya

---

— As you said it automatically get switched off after every three days.. is the timings of day when SQL shut down are also same. if its so, you can run sql profiler and be ready to check who all users have connections with server and check for applications running/contacting this prod server. any errors in SQL Error and Events logs before it shutdown?? Deepak Kumar –An eye for an eye and everyone shall be blind

---

hi,
have you check Error log and event viewer for error ! have you observe what if after installig patches and hot fixes ! Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami

---

]]>