In this video we take back up and restores a little further. Typically DR requires backups such as a full backup on a weekend, differential backups at the end of each day and transaction log backups every 15 minutes. This is the kind of DR strategy you would typically find in most companies. In this video will demonstrate how to set this up and how to restore the data in the correct order to achieve our RPO ( recovery point objective) and RTO (recovery time objective)


Every DBA should be familiar with the steps required to restore a database to any point in time. In order to achieve this a good understanding of the current state of backups is critical. Companies often test their DR plans over long holidays to ensure they are prepared in the event of an emergency.

Need more information?
Visit [ Ссылка ]

To know more about Jayanth Kurup visit [ Ссылка ]

Jayanth is a Microsoft SQL Server trainer / consultant with over 15 years experience. He has worked with companies like Microsoft, IBM, HCL , Wipro , WellFargo , Zeomega and many more. He is based out of Bangalore and a very active member of the SQL Server Community.

In this channel he covers complex topics related MS SQL Server , PowerBI , Azure , AWS , Powershell, SSIS , SSAS , SSRS , Machine Learning , AI , etc

You can also reach Jayanth via his LinkedIn profile below
[ Ссылка ]

свернуть