Using transactional replication and wanted to know if we change the recovery
model from simple to full or vice versa while replication is in place, does
it break anything ? Using SQL 2000
Thanks
nope, change away with no impact. However with full you will have to
maintain your log with more frequent dumps especially if your server is
under high load.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:uUrkgx54EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Using transactional replication and wanted to know if we change the
> recovery
> model from simple to full or vice versa while replication is in place,
> does
> it break anything ? Using SQL 2000
> Thanks
>
Thursday, March 8, 2012
changing recovery model to databases : replication
Labels:
changing,
database,
databases,
microsoft,
model,
mysql,
oracle,
recovery,
recoverymodel,
replication,
server,
sql,
transactional,
versa,
vice
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment