Thanks again for all your help! Much appreciated it.

What a nightmare making a phone call to Microsoft was...I can't even being to express how much the entire experience was a waste of both the time and money spent....

If this is a production box I wouldn't reccomend switching anything to simple mode...just throwing that out there (as I'm sure you're already aware)

Without knowing the details (i.e. how large...

Sounds like a school project 😉 That being said I doubt anyione in the forum will do it all for you...If you're tinkering with SSIS you should already know...

No. We had a full down at that point in time the diff was taken.

We're kind of in a bind here with our corporate reporting...I've opened a call with MS tech support - see where that goes...

🙁

There is an additional snapshot publication that runs twice daily but that's wokring just fine.

I have 3 databases replicating (each with about 30 tables), each having 1-2 snapshot replication runing...

No luck...

I can't believe this is a problem after deleting the publication and subscriptions...

On my production box, I opened up a new window/connection.

Ran sp_repldone NULL, NULL, 0, 1 (the defaults)

(it said it was successful)

Went to the Replication monitor, stopped the log reader agent,...

This is coming from the Log Reader Agent:

Error messages:

The process could not execute 'sp_repldone/sp_replcounters' on MyServer. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011)

Get help: http://help/MSSQL_REPL20011

The log scan number (193864:92424:1) passed to log...

Okay, I deleted the publisher for the database I was replicating and the subscriptions on the other server.

Recreated the publisher and added the articles I needed and ran the job...

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 to...

I've also had good experiences using EXCEPT, as long as you've got some decent indexes on the table you're hitting.

INSERT INTO Local.Table

SELECT col1, col2... FROM Remote.Table

EXCEPT

SELECT col1, col2... FROM Local.Table

This...

You could try adding a column to the end of the remote table that has a default value of GETDATE so as records get added to the remote table, they...

I am facing a similar issue. I usually do my own custom logshipping but with this particular project (attempting to logship from '05 to '08 with the '08 DB's...