Level: Intermediate to Advanced
When choosing the appropriate SQL Server High Availability and Disaster Recovery (HA/DR) solutions, it is important to understand the SQL Server Transaction Log as it affects any solution you choose. In this session, we will look at transaction log basics, how logging and recovery works and how it affects all of the HA/DR solutions available in SQL Server. You'll be surprised to know that the transaction log is the most important part of your database.
You will learn:
- How the transaction log works
- How the transaction log affects all of the SQL Server HA/DR solutions that you choose
- How to properly take care of the transaction log for performance and HA/DR