Which recovery model causes all changes to the database to be written to the transaction log?
A)simple recovery model
B)full recovery model
C)bulk logged recovery model
D)truncated recovery model

Question

Quizplus · Accepted Answer

The full recovery model causes all changes to the database to be written to the transaction log. This allows for point-in-time recovery and the ability to restore to a specific point in time, which is not possible with the simple or bulk logged recovery models. The truncated recovery model is not a valid recovery model option.

Which Recovery Model Causes All Changes to the Database to Be