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

How to Learn MS SQL Server Version

How is Sqlcmd Different from Osql ?

What is SQL Injection in SQL Server ?

What is Deadlock in SQL Server ?

How is Deadlock Different From a Blocking Situation in SQL Server ...