SQL Server Quickie #35 – Crash Recovery

Today I have uploaded SQL Server Quickie #35 to YouTube. This time I’m talking about Crash Recovery in SQL Server.

Like or share to get the source code.

Thanks for your time,

-Klaus

2 thoughts on “SQL Server Quickie #35 – Crash Recovery”

  1. Hi Klaus,

    Thank’s for your demonstration.

    Since the checkpoint occurs in different time depending of “recovery model” that the DB has , my question is if the recovery model is “Simple” , the only transactions that are lost are the Noncommited operations.

    Regards

    1. Klaus Aschenbrenner

      Hello Pedro,

      The recovery model of the database has no influence if you can loose transactions. Even in “Simple” SQL Server shows you the same behavior. The difference of the recovery model is how SQL Server deals with the clearing of the transaction log.

      Thanks,

      -Klaus

Leave a Comment

Your email address will not be published. Required fields are marked *

Attend my next Live Training on May 3, 2022:

SQL Server Query Tuning Fundamentals

EUR 590 incl. 20% VAT