The current database recovery process Analysis phase. SQL Server conducts a forward scan of the transaction log from the beginning of the last successful checkpoint (or the oldest dirty page LSN) until the end, to determine the state of each transaction at the time SQL Server stopped. Redo phase. ... Undo phase. Apr 2, 2023