recovery model and replication | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

recovery model and replication

Hi, 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.
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |