Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
 Posted - 2007-11-09 : 10:02:26
|
| I have production server 2000. The server gets disconnected sometime by itself and sometime it is working fine.Sometimes it even doesn't get restarted. Is there any problem with service packs and some performance issues.Can you SQL guru give me best suggestion and how should i proceed. |
|
|
sshelper
Posting Yak Master
216 Posts |
Posted - 2007-11-09 : 10:10:35
|
| Check the messages in your Event Viewer and see if SQL Server logged anything related to the error you are encountering.SQL Server Helperhttp://www.sql-server-helper.com |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-09 : 23:32:29
|
| Check sql server log too. What's sp level on the server by the way? |
|
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2007-11-11 : 18:07:20
|
| Could be DNS problem is there a ttl on the dns if so get network guy to remove it....sometimes the name is not being registered on domain and this can prevent sql working. |
|
|
|
|
|
|
Production Server Probs