SQL Server Quickie #35 – Crash Recovery

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

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,



  • Pedro Faro

    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.


    • 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.



It`s your turn

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


Copyright © 2018 by SQLpassion e.U. · Imprint · Offerings · Academy · Contact · Data Protection · Go to Top