- You have a linked server configured between a local server and a remote server.
- You have a client application that runs a distributed query against a large table in Microsoft SQL Server 2008 R2, SQL Server 2012, or SQL Server 2014. The large table is on the remote server.
- The remote query session is halted forcedly on the SQL Server that contains the database for some reason. For example, the remote query session is halted forcedly due to log shipping or database restore.
Article ID: 2890095 - Last Review: Apr 21, 2014 - Revision: 1