Hmmm,

I have had a very similar scenario, but I think my problems were different to yours.

Have you tried to run a simple job step with the proxy account that does...

Out of interest, what service pack are you running on your SQL 2000 server ?

Graeme

Have you checked how the multiple rows are being generated.

Look at the replication tables on the subscriber and test what happens when you make a change to a record.

Graeme

So the records are in the publisher and the subscriber but you want to remove them from the subscriber.

Not sure that's the right thing to do ??

IS the data not...

Hi,

Well, unless you can get some downtime, I'm not sure you are going avoid losing some records..but i could be wrong.

You will need to remove the table from the publication...

I think you would be better off leaving replication to manage uniqueness, by all means have your own PK.

How much data are we talking about here ?

How big are the tables?

What is happening to the data before it is inserted ?

Need a bit more to play with I'm...

Great article Stephen.

Yes it does open a can of worms with regards to poor development, bad communication etc...but i still think it needs an article like this to remind people...

Can't you use a program like 7Zip (Free) or the command line version of Winzip and and run this from within a sql job after the backup has run....you can...

Still not sure this is the right way to go. The whole updateable subscriber scenario implies you want to modify records both ends. If you delete records from the external...

Not quite sure what you are trying to do...are you trying run a sql backup from a scheduled task ???

Graeme

Hi,

Is replication right for you here then ?

Do you need just some of the data replicated ?

Need a little more..

Graeme

I assume after you have added the new table in you will run the snapshot agent and then distribute that new table..correct.

Once you drop an article from replication you can...

Without knowing much about your configuration...

I think it would be safer to set up your replication from scratch. You can use a 'nosynch' approach so you don't have to push...

Do you have Merge replication configured ?

What is your setup ?

I think more info is required.

Thanks

Graeme