| Author |
Topic |
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
 Posted - 2008-06-10 : 13:18:31
|
| MS SQL server 2000 sp4Added one article to replication a couple of weeks ago and just realized that it's no replicating. when I do asp_helpsubscription @publication = 'MY publication' I see the article.. but it's not replicating. did a new snapshot and that didn't work.doing transactional replication. log reader is running all the time and the distribution agent runs once evey 15 mins.. can anyone help????? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
Posted - 2008-06-10 : 13:43:05
|
| I don't see any errors in replication monitor |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-10 : 13:46:57
|
| Did you select the Reinitialize option after you added the article? A snapshot will not run unless you reinitialize it.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
mdubey
Posting Yak Master
133 Posts |
Posted - 2008-06-10 : 13:54:56
|
| Did you check the article in Publisher and start the snapshot agent?ManojMCP, MCTS |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-10 : 13:55:39
|
quote:
Originally posted by mdubey
Did you check the article in Publisher and start the snapshot agent?
That was answered in his first post.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
Posted - 2008-06-11 : 10:17:43
|
| I reinitialized the subscription and then waited the 15 mins for my REPL agent to kick off. the one table is still not replicating.. ??? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
Posted - 2008-06-12 : 13:42:59
|
| i believe I did.. so is that the proper sequence of events?reinitialize, snapshopt REPL distribution job? do I have to stop the log reader while doing this???I've added articles to this publication before - i don't know why I am having such a problem with this.. it's obviously a PICNIC..Problem In Chair Not In Computer!! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-12 : 14:00:19
|
| That's the procedure I was trained to follow by someone with practically expert knowledge of replication. I have had issues with it though.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
Posted - 2008-06-16 : 11:12:06
|
| Thanks Tara. I am beyond frustrated with this. I have one table that just will not replicate. Last night I used sp_droparticle to drop it from the publication and then truncated the table on the subscriber side.. I reinitialized, did a snaphot and then let my distribution agent take off.. it ran for a long time and never replicated my one table. I have been looking for some kind of replication log or history log so that I can see what is going on.. can't find that either. |
|
|
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
Posted - 2008-07-28 : 03:57:09
|
| table exists on the subscriber DB but with zero rows.. table exists on the publisher with the correct primary key for replication...I tried this.. Exec dbo.sp_droparticle @publication='TowerDB to KOCSQL03', @article='tower.COD',@force_invalidate_snapshot=1Exec dbo.sp_refreshsubscriptions 'TowerDB to KOCSQL03'thenExec dbo.sp_addarticle @publication='TowerDB to KOCSQL03', @article='tower.COD', @source_table= 'tower.cod' , @destination_table= 'tower.cod' ,@force_invalidate_snapshot=1Exec dbo.sp_refreshsubscriptions 'TowerDB to KOCSQL03'reinitialized then did a snapshot and REPL Distribution...TABLE still not replicating?????? when I dosp_helpsubscription @publication = 'Towerdb to kocsql03' I DO NOT see my new table.. what the heck am I doing wrong???????? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-28 : 21:59:11
|
| Tried this one on publisher yet?sp_changepublication '<Publication_Name>','immediate_sync','true' |
|
|
|
MAzim
Starting Member
1 Post |
Posted - 2009-02-09 : 06:38:25
|
quote:
Originally posted by rmiao
Tried this one on publisher yet?sp_changepublication '<Publication_Name>','immediate_sync','true'
Although this blog is too old, but I want share resolution to a same type problem I was facing after installing the cumulative pack 9 on my SQL Server 2005 instances. The new tables were successfully added and got synchronized prior to installing cumulative pack 9.A brief description of Replication configured in my case is as1. SQL Server 2005 64 bit sp2 and cumulative pack92. Windows Server 2003.3. Replication Type: Transactional (initialization with backup)4. Subscription type: PushPublications created with subscription initialization with backup have default value "False" for "immediate_sync" propertyBy changing its value to true in instances where cumulative pack 9 is installed, subscription started to synchronize all new tables.rmiao thanks alot on indicating such an important option. |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-02-09 : 17:20:12
|
| When you add the article, do you see rows being added to the tabl ein subscriber ? or does that never change?Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
|
replication not working for one new article