SQL Server Performance Forum – Threads Archive
Replication failure
Does the replication failure (when subscriber database is restored incorrectly – see link) apply to push transactional replication as well as pull transactional replication? http://support.microsoft.com/?scid=kb;en-us;304091&spid=2852&sid=266 ThanksThe RESTORE DATABASE command removes all of the replication objects and replication jobs from the restored database that cause the Distribution Agent job of the original database to be deleted because the Distribution Agent job_id is the same for both the original subscribing database and the restored database.
.. this applies to both the replication types. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>