What are the Different Recovery Models Inside SQL Server ?

There are 3 different recovery models inside SQL Server...

Simple Recovery model – with minimum administrative overhead for the transaction log, the simple recovery model risks significant work-loss exposure if the database is damaged. Data is recoverable only to the most recent backup.

Bulk-Logged recovery model – Used for bulk operations, for large-scale such as bulk import or index creation, switching temporarily to the bulk-logged recovery model increases performance and reduces log space consumption. Log backups are still required.

Full Recovery Model - The full recovery model guarantees the least risk of losing work if a data file is damaged. In this model, SQL Server fully logs all operations. In this recovery model, you can recover to a Point-in-time and is the most recommended model for financially systems.



You May Interest

What is a View in SQL Server ?

What are the Events On Default Trace in SQL Server ?

Adding Columns to a Table with a Query in MS SQL

Disable All Triggers in MS SQL Server Table

What is the Maximum Number of Columns a Table in SQL Server ?