Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Cannot Kill SPID
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

itsonlyme4
Posting Yak Master

109 Posts

Posted - 05/04/2015 :  09:55:27  Show Profile  Reply with Quote
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

Sweden
30421 Posts

Posted - 05/04/2015 :  10:14:32  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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 - 05/04/2015 :  10:48:32  Show Profile  Reply with Quote
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

Sweden
30421 Posts

Posted - 05/05/2015 :  06:50:27  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000