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”

Pedro Faro
05/09/2016 at 4:09 PM

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
  05/10/2016 at 12:55 PM
  
  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 Cancel Reply

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.