Tag Archives: sql server recovery model

10 Difference between SIMPLE vs FULL recovery model

What are the difference between SIMPLE and FULL recovery Model ? BASE SIMPLE Recovery Model FULL Recovery Model Incremental Backups Transaction LOG database backup options are not available in Simple recovery Model. Transaction LOG database backup options are available in FULL / Bulk Logged recovery Model. POINT in Time Recovery Point in Time recovery is not supported. [...]