crash recovery Archives - SQLServerGeeks

SQL Server Transactions – How to deal with Deferred Transactions?

November 29, 2013September 10, 2014 - by Kanchan Bhattacharyya - Leave a Comment

Dear Friends, Few weeks back, I blogged on SQL Server Transactions Deferred Transactions which I thought is not complete if I do not write on how we deal with them in general? To …

SQL Server Deferred Transactions what are they?

October 6, 2013September 11, 2014 - by Kanchan Bhattacharyya - Leave a Comment

Dear Friends, Just think of a scenario when your system crashed and reboots unexpectedly. As your SQL Server restarts so it has to run recovery on all databases. Bad thing is …

SQL Server fast recovery

September 21, 2013September 27, 2014 - by Kanchan Bhattacharyya - Leave a Comment

Hi Friends, Today we will understand SQL Server fast recovery. To start with, there are number of cases before SQL Server 2005 wherein databases aren’t accessible because length of recovery time …