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 |
|
hannah00
Starting Member
31 Posts |
 Posted - 2005-03-30 : 11:26:41
|
| Is there any way we can kill the process from the OS instead of wating till the process finish rolling back???? I am Oracle DBA and I know it's possible in Oracle so I figure it's possible in MSSQL too.Please advise. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-03-30 : 12:07:36
|
| When you say rolling back do you mean the transaction is rolling back in the database? If so then you will have to wait for this to complete.You can kell a connection using the kill command but this will roll back the transaction.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
hannah00
Starting Member
31 Posts |
Posted - 2005-03-30 : 14:16:20
|
| yes the transaction rollback in the database. What the transaction is so big and I have to wait for hours, does it mean that I can't do much exept waiting??? Another word, the DBAs won't have much power under this scenarios except stop/start the services. If this is the case and it's not good if you have 24x7. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-03-30 : 20:52:46
|
| A rollback takes as long as it takes...if you restart SQL Server it will simply pick up the rollback during the startup recovery period. |
|
|
|
hannah00
Starting Member
31 Posts |
Posted - 2005-03-31 : 17:34:38
|
| you miss my point. my point here is that if you sit there and wait for as long as the transaction to rollback, then it's not good if you have mission critical. Seems like you don't have much control over the database instead of waiting.In Oracle, I can kill any process at anytime even the process is in the midle of its job. |
|
|
|
TimS
Posting Yak Master
198 Posts |
Posted - 2005-03-31 : 18:15:19
|
| So it's either easy for Oracle to rollback or it does NOT care about keeping good data in the DB.Tim S |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-03-31 : 20:51:47
|
| lolIt actually depends on how you setup the transaction in Oracle. In SQL Server 2005, you have a little more control over this. The bottom line answer to your question though is "no".MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
kill process from OS