连接失败或超时时的事务回滚

This question is asked by Navaneeth Adruguli on Link Of form

这个问题由Navaneeth Adruguli在Link Of form上提出

---

The question is:
In SQL server how transaction rollback will work? If i have a huge number of updates in a transaction and during update connection failure or connection timeout occurs then what will happen?Can sql server rollback in this conditions without connection to the sql server(in case of conection failure).If possible then how?

1 个解决方案

#1

SQL Server rollback the transaction if any error occurs in network of system. It can even automatically restore from crash if system crashes or shuts down in between.

如果在系统网络中发生任何错误,SQL Server将回滚事务。如果系统崩溃或在两者之间关闭,它甚至可以自动从崩溃中恢复。