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.
Thanks for your time,
-Klaus
2 Comments
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
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