Yesterday one of my clients SQL servers went into a recovery mode and it
lasted almost the entire day. We could not access the serve database to see
the server logs for monitors process locks or anything. After the recovery
completed itself our database was back up and with no data loss and the log
indicated the following.



Recovery of database 'DTT5' (7) is 100% complete (approximately 0 more
seconds) (Phase 3 of 3).

1 transactions rolled back in database 'DTT5' (7).

Recovery is checkpointing database 'DTT5' (7)



I am researching the find out what caused this. The server logs are
incomplete and begin at the point of recovery.



Please advise.



Thanks



Paris










MS Sql Server LazyDBA home page