Which recovery model is required for a replication in SQL Server ?

 Posted by PandianS on 1/30/2011 | Category: Sql Server Interview questions | Views: 4880 | Points: 40
Answer:

1. Replication will work properly with any of the following recovery models:
Simple
Bulk-logged
Full.

2. Merge replication tracks change by storing information in metadata tables.

3. Transactional replication tracks changes by from the transaction log, So, it will not affected by the recovery model.

www.sqlserverbuddy.blogspot.com


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response