Wednesday, March 28, 2012

Recovery Mode and Replication

Is there any requirement for either the publisher or subscriber to have
full recovery model enabled when using transaction replication.
No, but put your subscriber in bulk copy mode when you are applying the
snapshot for a faster deployment.
I normally put my publication database in full recovery model and dump
frequently to make life easier for the log reader.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Paul" <sueme.sucker@.gmail.com> wrote in message
news:1138896281.822489.160290@.g47g2000cwa.googlegr oups.com...
> Is there any requirement for either the publisher or subscriber to have
> full recovery model enabled when using transaction replication.
>
|||Nope. Replication will still work in any recovery model.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Paul" <sueme.sucker@.gmail.com> wrote in message
news:1138896281.822489.160290@.g47g2000cwa.googlegr oups.com...
> Is there any requirement for either the publisher or subscriber to have
> full recovery model enabled when using transaction replication.
>
|||Thanks for the quick reponses

No comments:

Post a Comment