rajemessage 14195 (1/29/2015)
1) please tel me how it handels snapshot transactions in database recovery ?
Same as any other other isolation level, uncommitted transactions are rolled back, committed transactions are re-done
2) In how many cases database goes in recover and how often?
Other than the log full scenario which you described, when SQL is restarted or the database is taken offline and brought back online
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability