SQL recovery models

You should use the full recovery model when you require point-in-time recovery of your database.

You should use simple recovery model when you don’t need point-in-time recovery of your database, and when the last full or differential backup is sufficient as a recovery point.

Recovery Models (SQL Server)


Choosing the Recovery Model for a Database


SQL recovery models