none
Stopat restore RRS feed

  • Question

  • To restore the database to a point of time I have been using full backup, differential backup and log backup. Storing all these backups needs space. I was thinking stopat restore could help because if we could restore to a point of time from full backup other backups would not be needed but stopat restore works only with log backup. In a sequence of full, differential and log backup each log backup contains changes after the last backup. Is it possible to take log backup since last full backup by skipping the differential and log backups?
    • Edited by Curendra Monday, August 26, 2019 9:08 AM
    Monday, August 26, 2019 9:00 AM

Answers

  • Correct, to stopping at a certain time when you restore can only be done using log backups.

    You need an unbroken sequence of log backups when you restore. You cannot "skip" a log backup in between, so to speak.


    Tibor Karaszi, SQL Server MVP (Web Blog)

    • Marked as answer by Curendra Wednesday, August 28, 2019 6:01 AM
    Monday, August 26, 2019 7:57 PM
    Moderator
  • Hi Curendra,

     

    Log backup is a prerequisite for point-in-time restore. You can do log backups regularly and build a log chain after performing a full backup, so you don't need to do differential backup.

     

    Best regards,

    Dedmon Dai


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    • Marked as answer by Curendra Wednesday, August 28, 2019 6:02 AM
    Tuesday, August 27, 2019 7:21 AM

All replies

  • Correct, to stopping at a certain time when you restore can only be done using log backups.

    You need an unbroken sequence of log backups when you restore. You cannot "skip" a log backup in between, so to speak.


    Tibor Karaszi, SQL Server MVP (Web Blog)

    • Marked as answer by Curendra Wednesday, August 28, 2019 6:01 AM
    Monday, August 26, 2019 7:57 PM
    Moderator
  • Hi Curendra,

     

    Log backup is a prerequisite for point-in-time restore. You can do log backups regularly and build a log chain after performing a full backup, so you don't need to do differential backup.

     

    Best regards,

    Dedmon Dai


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    • Marked as answer by Curendra Wednesday, August 28, 2019 6:02 AM
    Tuesday, August 27, 2019 7:21 AM