July 7, 2004 at 3:21 pm
I'm running SQL 2000 (no service packs), and we're trying to apply all SP's up to 3a. There is some unusal behavior in the server that is preventing us from doing so. The SQL service won't stop correctly, it just says "Stopping" after a "shutdown" command. The errorlog indicates that SQL has received the stop request from the service control manager. This has been happening for quite sometime, but I'm not sure exactly when it started. The only way to cycle the SQL server is to reboot the whole box.
On a possibly related note...I can't kill any spids in the server....ever. If I execute a "KILL" command against any user spid, I always get this error:
Server: Msg 6101, Level 16, State 1, Line 1
Process ID 62 is not a valid process ID. Choose a number between 1 and 32817.
Any ideas? Maybe a SHUTDOWN WITH NOWAIT?
-Dan
July 7, 2004 at 11:44 pm
You're going to think I'm crazy. I would make a backup of all your databases (making sure you include the system databases), script out your users, detach the databases, uninstall SQL Server, and start over if I had been running very long without any service packs at all. Just do a clean install.
Derrick Leggett
Mean Old DBA
When life gives you a lemon, fire the DBA.
October 6, 2004 at 2:56 pm
Just an update, we ended up bringing in new hardware (not b/c of this problem though). I just set up the new machine with SQL 2000 SP3, RESTOREd all the databases, and ran DBCC's for good measure. Everything works great...must have been a problem with SQL SP1 itself.
Thanks for the reply DL.
-Dan
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply