Posts
Sort by recent activity
SQL connection timeout after 100 minutes
I'm trying to do a data compare on a single table between 2 servers. This runs every hour and works most of the time. However, every couple of days I consistently get the following error (after 6...
replication time just doubled (even with no table changes)
In the past week I've notice that the replication time (when not timing out) has increased significantly. Our set of SQL tables replicated in under 11 minutes last week. Currently, it's taking 20...
how can I increase Timeout (or set to 0)?
I'm using the the ExecuteBlock class to replicate data from one server to the other. How can I set whatever SQLCommand.Timeout that this class is using. Currently, I'm timing out after 2 hours.