What is the recovery model in SQL Server?

Question

Accepted Answer

Recovery model in SQL Server determines how transactions are logged and how the database can be restored.

There are three recovery models in SQL Server: Simple, Full, and Bulk-Logged.
Simple recovery model automatically truncates the transaction log and only allows restoring to the most recent full or differential backup.
Full recovery model logs all transactions and allows restoring to a specific point in time using transaction log backups.
Bulk-Logged recovery model is similar to the Full model but minimally logs bulk operations to reduce log size.
The recovery model should be chosen based on the desired level of data protection and the ability to recover from failures.

Accepted Answer

Recovery models explains about the strategy of a backup, depending upon recovery model backups are scheduled in sql server.There are three types of recovery models existed

1) Full recovery

2) simple

3) Bulk logged

What is the recovery model in SQL Server?

Top HR questions asked in Infosys SQL Server Database Administrator