Snapshot replication doubts.

Question

Transaction replication for big tables is taking 3 hours to apply all it is transaction to the Subscriber.

My goal is to have transaction up to date in subscriber without any delay in applying changes. Is there any option in sql server?

If i am configuring Snapshot replication and reinitializing it, does it apply only the incremental changes happened at the publisher side or it will apply whole snapshot of the articles again?

Answer 1

I am assuming you mean that applying the snapshot of the transactional replication publication takes 3 hours. In this case you should look at the initialize from backup option.

---

looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941