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

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

Hey thanks for the reply!!! I realize you can use the NORECOVERY option but that keeps the DB in a mode where we can't test anything as the DB's...

Can you please suuply the TSQL code you're using?

Ex:

EXECUTE msdb.dbo.sp_send_dbmail @recipients = 'jdoe@gmail.com'

, @subject='Test', @body = 'Test'

Also, you may want to check the settings in >> Management >> Database Mail...

This could happen for MANY reasons...without knowing your configuration for both SQL and your Server. Considering this occurs at 20-min intervals it sounds like something is scheduled and running....so...