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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-07-02 : 09:09:49
|
| Syed writes "How can I kill a process which is already killed and is in Rollback mode. It is taking so long that effecting the other process.I was updating a table with about 44 million records. Since it took about 16 hrs and was still going on, I killed that process. I don't need that table any more.Could anyone tell me how can free my resources?Thanks," |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-02 : 09:32:46
|
| You can't. You need to let the rollback finish. You could restore from a backup as an alternative. That's not usually an attractive option either.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-07-02 : 11:47:58
|
| A rollback will usually take more than twice as long as the udate...I've seens some procedures discussed on this site...but involves taking the box down. Is that an option?Brett8-) |
|
|
|
|
|
|
Killing Rollback process