Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 subscription problem

Author  Topic 

avijit_mca
Posting Yak Master

109 Posts

Posted - 2010-04-15 : 00:08:11
Hi,
i am going to develope peer to peer transcational replication.

server 1: i have create distributor, & publish it.
server 2: but i m not able to subscribe.

pls tell me the step for doing it

Regards,
avijit

avijit_mca
Posting Yak Master

109 Posts

Posted - 2010-04-15 : 00:34:23
error messager when creating subscription :
peer to peer publication only supporta @sync_type' parameter value of 'replication support only'.... etc

Regards,
avijit
Go to Top of Page

suba anand
Starting Member

5 Posts

Posted - 2010-04-15 : 02:12:36
create subscription with @sync_type as 'replication support only'

see below msdn link for more information
http://msdn.microsoft.com/en-us/library/ms146914.aspx
Go to Top of Page

avijit_mca
Posting Yak Master

109 Posts

Posted - 2010-04-15 : 06:41:49
i hv tried like that way ...means..run wizard then create script & change script & then run script... but some others errors r coming

Regards,
avijit
Go to Top of Page

suba anand
Starting Member

5 Posts

Posted - 2010-04-15 : 07:52:32
what is the error? can you post the subscription creation statement?
Go to Top of Page

avijit_mca
Posting Yak Master

109 Posts

Posted - 2010-04-17 : 05:43:50
the database is not enable for publication

Regards,
avijit
Go to Top of Page

avijit_mca
Posting Yak Master

109 Posts

Posted - 2010-04-20 : 01:19:37
finally i have done configuration. but if i update in publisher its not updating in subscribe db.

Regards,
avijit
Go to Top of Page
   

- Advertisement -