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?
>
Wednesday, March 28, 2012
Recovery model in replication
Labels:
database,
microsoft,
model,
mysql,
oracle,
recovery,
recoverymode,
replication,
server,
sql,
thereif,
transactional
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment