Wednesday, March 28, 2012

Recovery model in replication

Hello there
If i use transactional replication on one server, can i set the recovery
mode to be simple?
Yes - it has no impact.
HTH,
Paul Ibison
|||It should be set to bulk logged on the subscription database while the
snapshot is being applied. After that it makes no difference.
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
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:eR$g%23s1zHHA.4476@.TK2MSFTNGP06.phx.gbl...
> Hello there
> If i use transactional replication on one server, can i set the recovery
> mode to be simple?
>

No comments:

Post a Comment