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 - 2008-10-30 : 07:09:14
|
| SQL Server 2000 with 32 DatabasesI startedEXEC sp_delete_backuphistory '12/31/07'about an hour ago and the Server is at a crawl. How do I go about killing this ??????? |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-10-30 : 07:33:09
|
| I guess you've never cleaned up the history on this server. You can kill it, but it will take just as long if not longer to roll back. |
 |
|
|
itsonlyme4
Posting Yak Master
109 Posts |
Posted - 2008-10-30 : 07:41:26
|
| no. I never have. I have only had the care of this Server for a couple of months... At this point, I will have to let it run I think...If I choose to kill it.. what would be the correct command syntax to kill this spid? |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-10-30 : 08:31:25
|
| kill <spid> |
|
|
|
|
|
|
Kill EXEC sp_delete_backuphistory '12/31/07'