Delayed Durability - Getting Started with SQL Server 2014 Administration - page 57

This leads us on to log shipping. If the transaction log backup only contains
transactions that have been made durable, then it stands to reason that only
backups that have been made durable will be shipped as part of log shipping.
Transactional replication will only guarantee the durable transactions will be
replicated. So again, if you work in a heavily replicated transaction or peer-to-peer
replicated environment, you will need to consider the data loss potential.
Summary
In this chapter, we have looked at Delayed Durability and how it can improve
performance. It is important that when making use of this new feature in SQL Server
2014, you consider the potential data loss. Delayed Durability is something you
should consider using if you have an I/O bottleneck or other related performance
issues that Delayed Durability fixes. Always consider the potential for data loss
and if that risk is acceptable to you. If the small amount of data loss that comes
with Delayed Durability is not a problem for you, then this can be a great way of
improving the performance of your databases. If, however, data loss, however small,
is not acceptable to you, then this feature is not for you, regardless of the performance
enhancement you can get from using it. In the next chapter, we will move on to the
new high availability features and enhancements in AlwaysOn Availability Groups.