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 |
|
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 1The 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 5Command: autoshrinkWait Type: LOGBUFFERWaitTime: 76153109 Memory usage: 3 Physical I/O: 181Cannot kill this SPID as it is a System process (receive this error:)Server: Msg 6107, Level 14, State 1, Line 1Only 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 |
 |
|
|
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... |
|
|
|
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 |
|
|
|
|
|
|
|
|
Cannot Kill SPID