In SQL Server,the full recovery model creates a log entry for every change to the database.

Question

Quizplus · Accepted Answer

The full recovery model in SQL Server ensures that every transaction is logged, which allows for complete recovery of the database to a specific point in time. Each change to the database is recorded in the transaction log, even if it is not yet committed to the actual database. This is in contrast to the simple recovery model which only logs the transaction that occur since the last backup.

In SQL Server,the Full Recovery Model Creates a Log Entry