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.
| Author |
Topic |
|
itsonlyme4
Posting Yak Master
109 Posts |
 Posted - 2009-06-09 : 15:27:55
|
| I am having a devil of a time getting one article (table) replicated. on my SQL Server 2000 instance I am replicating some of the tables in one of the databases to another Server (off-site) Replication is set up to do a snapshot once a night. Run log reader continuosly and the REPL distribution agent once every 15 mins.I have one table that I can get to sync up. It has 6 columns - all INT (10) with the same primary key on both the publisher and subscriber (primary key is Indentity column on the publisher) The table was badly out of sync so I did the following: [CODE]exec sp_droparticle @publication = 'MYPUB', @article = 'mytable'exec sp_addarticle @publication = 'MYPUB', @article = 'mytable , @source_table = 'owner.mytable' exec sp_addsubscription @publication = 'MYPUB', @article = 'mytable, @subscriber = 'SUBServer' , @destination_db = 'MYDB' [/CODE]Once I dropped and then added the article back into the subscription, I took a snapshot and then ran the REPL distribution agent. I'm doing something wrong because my table is still out of sync. can anyone help?? |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-06-10 : 10:27:34
|
| You also need to drop the article out of subscription..using sp_dropsubscription (just like what you have for adding it back).Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
|
|
|
SQL Server 2000 replication