Transaction log archiving and recovery

After our brief introduction to the transaction log in general, it is time to focus on the process of transaction log archiving. As we have already seen, the transaction log contains a sequence of binary changes that are made to the storage system. So, why not use it to replicate database instances and do a lot of other cool stuff, such as archiving?

Configuring for archiving

The first thing we want to do in this chapter is create a configuration to perform standard point-in-time recovery (PITR). There are a couple of advantages of using PITR over ordinary dumps:

• We will lose less data because we can restore the data to a certain point in time and not just to the fixed backup point.
...