I had a situation where my SQL Server was stopped in the middle of a long running transaction, I knew that when SQL Server came up, there would be a substantial wait before the database became available again.
When SQL Server came up, the database was in a recovery state. I checked the logs and it showed "recovery of database.... Phase 2 of 3"
What confused me is that after phase 2 of 3, the database went into and Online State but the logs showed "recovery of database.... Phase 3 of 3"
I allowed phase 3 to complete before starting the application that uses the database
My question is, could I have started using the database during the 3rd phase already, was it unnecessary to have waited for phase 3 to complete?