Posted by Query Builder on 10/03/06 14:32

I have a transactional replication working fine till to date. I have
the publisher on ServerA and subscriber on ServerB. The transactional
replication is running fine...

I need to get a copy of the subscriber to another server and replicate
the Publisher to that serverC while the replication on ServerB is
running.

ServerA.Publisher ---> ServerB.Subscriber (runs transactional
replication)
ServerA.Publisher ---> ServerC.NewSuscriber (This need to run without
impacting ServerB.Subscription). I cannot resynch the databases as It
will take days to resynch and will also kill some of my data on the
ServerB.subscriber that is not in ServerA.publisher

I went with the way they had explained on MSKB 320499. I stoped the
transactions coming into the publisher and copied a full backup of
publisher to ServerC. I created the new subscription wihout re-synch
option to ServerC. I also copied all the sp's that are needed from
ServerB.Subscriber.

When i try to enable the distribution agent between ServerA and ServerC
i get the following error..

{call sp_MSget_repl_commands(11, ?, 0, 7500000)}
Timeout expired
Timeout expired
(Source: ODBC SQL Server Driver (ODBC); Error number: S1T00)
---------------------------------------------------------------------------------------------------------------

The replication agent from ServerA to ServerB is running fine..! (Thank
God..!)

Can anyone help me figure out how to fix this issue between
ServerA.Publisher to ServerC.Subscriber?

Thanks in advance...!

[Back to original message]