Does A Specific Recovery Model Need To Be Used For A Replicated Database?
Answers
helo the first one of those of a lot to me so long I am not familiar in a lot for the use the right thing is a link
Answer:
You need to keep in mind that replicating database is certainly an important task especially if you want to encrypt data. So when speaking of replicating database, you may have to keep few important points in mind.
Explanation:
It is important to understand that the process of replication of any functions is important and so should be performed perfectly. It is also important to understand that you can actually make use of any possible recovery models that are available.
In general, presently three distinct recovery models can be used :- Simple, Bulk or full Logged.
When performing this task using any one of the above mentioned methods, you need to keep in mind to merge replication tracks such that any possible changes made to the tracks can easily be monitored. This is important so the information can actually be stored with ease in metadata tables.
When making use of transition replications methods, it will be designed to tracks all possible changes making use of the marked transition logs. But at the same time you also need to keep in mind that using this particular method may not be affected when making use of the recovery model.