You are here: Trasactional Replication Times Out...! - Help!!!! « MsSQL Server « IT news, forums, messages
Trasactional Replication Times Out...! - Help!!!!

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...!

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация