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)
 Kill EXEC sp_delete_backuphistory '12/31/07'

Author  Topic 

itsonlyme4
Posting Yak Master

109 Posts

Posted - 2008-10-30 : 07:09:14
SQL Server 2000 with 32 Databases

I started

EXEC 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.
Go to Top of Page

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?
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2008-10-30 : 08:31:25
kill <spid>
Go to Top of Page
   

- Advertisement -