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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Cannot Kill SPID

Author  Topic 

itsonlyme4
Posting Yak Master

109 Posts

Posted - 2015-05-04 : 09:55:27
I have a SQL Server 2000 Database. 30+ GB with a 15+GB log file.

I attempted to backup the Database and I receive the following error:

Server: Msg 9001, Level 21, State 1, Line 1
The log for database 'MYDB' is not available.

I then checked the Activity log and I see a System process associated with this Database:
Process ID 5
Command: autoshrink
Wait Type: LOGBUFFER
WaitTime: 76153109
Memory usage: 3
Physical I/O: 181

Cannot kill this SPID as it is a System process (receive this error:)

Server: Msg 6107, Level 14, State 1, Line 1
Only user processes can be killed.



Can anyone help with this?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2015-05-04 : 10:14:32
No. You can't kill system processes (normally denoted with spid values below 50).



Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
Go to Top of Page

itsonlyme4
Posting Yak Master

109 Posts

Posted - 2015-05-04 : 10:48:32
Wait time at 76153109 secs!

Is there any other way to kill this? I was thinking of cycling the instance but I can't get a good DB backup...
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2015-05-05 : 06:50:27
Your best bet is to turn off "Auto shrink" for the database.
Wait time is nothing since the spid is idle.


Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
Go to Top of Page
   

- Advertisement -