recovery model and replication | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
recovery model and replicationHi, We have a setup with transactional replication..The databases are in full recovery mode..
Can we have DB’s in simple recovery mode in replication????????????????
Also pls let me know the kinds of recovery models that suit for all kinds of replications
You can have SIMPLE recovery model for replication but incase of server failure your can’t recover upto the point…if you are not worried about database recovery issue incase of disaster then SIMPLE should be fine.
Will all kinds of replication( transactional, with updatable and merge) work with simple recovery model. Please sugest soon as we have to implement this on a customer server
You need the FULL mofrl if you are using replication and need the ability to resynchronize all databases involved in replication to a specific point in time.