Saturday, February 25, 2012

Connecting SQL 2k to SQL7

While connecting a SQL 2k server to a SQL 7 server to
replicate data, the connection is slow to the point where
the connection times out. The connection is be established
over a full T1 line. Any ideas on how to resolve this
issue?What replication model are you using? One of the reason for replication
time-out is blocking on the subscriber. Make sure you don't have blocking
proccesss on the destinatin database.
Richard
"Paul S. Atkinson" <PAtkinson@.AppliedPsych.com> wrote in message
news:047c01c34a42$b8ff6c70$a101280a@.phx.gbl...
> While connecting a SQL 2k server to a SQL 7 server to
> replicate data, the connection is slow to the point where
> the connection times out. The connection is be established
> over a full T1 line. Any ideas on how to resolve this
> issue?

No comments:

Post a Comment