locked
Old restore point for automated backups? RRS feed

Answers

  • Hello,

    Automatic log backups occur every 5-10 minutes. Full and differential automatic backups also occur periodically. The date you are seeing is just the oldest automated backup available to restore. In case of a restore Azure service will determine which backups are needed for the restore.


    If you need more control over backups you should consider long term backups.


    Hope this helps.



    Regards,

    Alberto Morillo
    SQLCoffee.com


    • Edited by Alberto MorilloMVP Thursday, January 18, 2018 12:29 PM
    • Marked as answer by AsusT9 Thursday, January 18, 2018 1:27 PM
    Thursday, January 18, 2018 12:29 PM

All replies

  • Hello,

    Automatic log backups occur every 5-10 minutes. Full and differential automatic backups also occur periodically. The date you are seeing is just the oldest automated backup available to restore. In case of a restore Azure service will determine which backups are needed for the restore.


    If you need more control over backups you should consider long term backups.


    Hope this helps.



    Regards,

    Alberto Morillo
    SQLCoffee.com


    • Edited by Alberto MorilloMVP Thursday, January 18, 2018 12:29 PM
    • Marked as answer by AsusT9 Thursday, January 18, 2018 1:27 PM
    Thursday, January 18, 2018 12:29 PM
  • Ah I see. Thank you for your answer.
    Thursday, January 18, 2018 1:27 PM