Back to Overview

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

    Regards

    Reply
    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

      Reply

Leave a Comment

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

SQLpassion Performance Tuning Training Plan – Signup

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.