In that situation getting the snapshot to recognize the changes can be sometimes problematic. The steps I sent should work IF you are ok with pushing a new copy of...

Did you put the table back in the same publication? Are there other tables in that publication? Here is my recommendation to get this fixed.

1. Pull the table out...

So, you pulled the table out of replication, made a change and put it back in replication? Did you send a new snapshot? At this point it would be...

When you say results are not replicated are you saying the physical object change did not replicate or you are not replicating...

You will have to add the scripting piece inline with the physical_device_name but shouldn't be too much work to get the syntax selected out;

selectbmf.physical_device_name

frombackupset bs join backupmediafamily bmf

on...

It may be sufficient but you should get something in writing stating that they can meet your service level agreement for recovery. If you have a requirement for a point...

Sounds like a good choice to use the call at this point. I'll be curious to see what you end up doing to get it working.

I would agree that it is remnants in the distribution database. I would NOT disable the distributor just disable that database from being a publisher and re-establish replication from there....

Definitely seems odd. Is that the only publication for that database? Assuming yes. The only other thing that I could say you could do is to remove the publication again,...

Ok, try the following;

use YourPublisher;

go

EXEC sp_repldone @xactid = NULL, @xact_segno = NULL, @numtrans = 0, @time = 0, @reset = 1

If that doesn't work then you can try sp_replflush...

And you ran that on the publication database? Sorry if I am asking picky questions but it makes a difference.

Checking some notes I have on this as well.

This is what I am referring to. Have you tried this?

"What you will need to do is stop the logreader agent for that database, open up an SSMS connection...

Did you try my first comment? Let me know.

MyDoggieJessie (3/4/2011)

---

Thanks for the quick reply. Do you have any idea how long the sp_replrestart should take? It;s been over 15 mins already and still going.

I am beginning...

One last note, please make sure that before you run sp_repldone, you are connected to the publisher and in the published database that you are having problems with. If...