如何处理已被转换中断的远程sqlserver? [英] How to handle a remote sqlserver which has been interrupted by a transction?

问题描述

如何处理已被转换中断的远程sqlserver?

How to handle a remote sqlserver which has been interrupted by a transction?

推荐答案

问题不是很清楚，但听起来像是您在在考虑如何正确使用两个或多个SQL Server实例之间的事务.

如果这是正确的，则该机制称为分布式事务.两阶段提交(2PC)用于确保在事务内部将所有事务修改正确提交到所有数据库中，否则将全部回滚.

看看:分布式事务(数据库引擎) [

The question isn''t very clear but it sounds like you''re thinking how you can correctly use transactions between two or more SQL Server instances.

If that is correct, then the mechanism is called distributed transaction. Two phase commit (2PC) is used to ensure that inside a transaction all transactions modifications are properly committed in all databases or otherwise all are rolled back.

Have a look at: Distributed Transactions (Database Engine)[^]

这篇关于如何处理已被转换中断的远程sqlserver?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！