Jump to content

Sql Snapshot Replication Problem


Recommended Posts

Posted

..i have two instances for same version...i created distributor and publisher in one instance and after i created subscriber in another instance...every thing is fine like distributor,publisher and subscriber installed successfully..
now i need to check whether it is really replication or not so, i done some dml operation in database what i need to replicate...after all i connected to my subscriber database and check the table..but it says error like no object was found..endhukani antaru..?

Posted

[quote name='babai2013' timestamp='1365389985' post='1303561888']
did you try tracer tokens ?
[/quote]
naku sql radu baya...nenedo sql nerchukuntuna practice chestuna....ayte replications chestuntey ravtledu/.... a tracer tokens antey ento telidu...

Posted

tracer token is test to ping if the replication is active across the publisher distributor and subscriber

Posted

[quote name='babai2013' timestamp='1365392295' post='1303562016']
tracer token is test to ping if the replication is active across the publisher distributor and subscriber
[/quote]
thanks baya i will try it..tracer token ni ela implement cheyalo chpeva or i will googlle it

Posted

u cannot insert a tracer token for snapshot replication, did u send a snapshot after initial setup? tables emi levu emo Sub lo chudu oka sari ?

Posted

[quote name='hhhhhh' timestamp='1365423726' post='1303563590']
u cannot insert a tracer token for snapshot replication, did u send a snapshot after initial setup? tables emi levu emo Sub lo chudu oka sari ?
[/quote]
ade subscriper lo oka database create chesanu while installing subscriber...a database create ayindhi andhulo, deafult ga emi tables vunadavu kada..
ikada nenu distributor and publisher vuna insatance lo ichina database ni modify chesi update chestey adi automatic ga subscriber instance lo create chesina databse lo chupinchal kada..kani ala avtaledu ...endhukani... malli sp_help 'tablename' ichi cusina asalu table name object ledu ani vastundhi subscriber instance lo..

×
×
  • Create New...