RPO with SQL Server

  • 0
  • 2
  • Question
  • Updated 4 years ago
  • Answered
What kind of RPO does Delphix have with SQL Server databases? Is it higher than with Oracle databases?
Photo of Johnston Davis

Johnston Davis

  • 634 Points 500 badge 2x thumb

Posted 4 years ago

  • 0
  • 2
Photo of Gabriel Martinez

Gabriel Martinez, Employee

  • 110 Points 100 badge 2x thumb
Official Response

SQL Server Recovery Point Objective ( RPO) will depend on how often Transaction Log backups are taken on the Source database.  The backup frequency time should be equal to or less than your desired RPO.  Oracle can pull the data almost real time from active redo logs by using the “Redo Logs + Archive log” option giving it an RPO advantage over SQL Server.