Post reply

SQL Server recovery

  • October 3, 2021 at 11:33 am

    #3936002

    Hi  There!

    Question related to recovery of SQL Server....When an SQL server crashes, from where does SQL server know the recovery path, as the buffer (RAM)contents are lost during crash ? Thanks in advance.

    Best Regards

    Arshad

  • October 3, 2021 at 7:42 pm

    #3936049

    From the transaction log.

    Any dirty pages lost in the buffer are redone via the log.

  • October 4, 2021 at 7:49 am

    #3936145

    Thank you @Ant-Green.That's possible due to the Write-Ahead log approach, got it...Thank you!

    • This reply was modified 3 years, 11 months ago by Arsh.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply