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

Listing Metadata of MS SQL Server Internal Tables

What is the Bookmark Lookup and RID Lookup in SQL Server ?

What is a View in SQL Server ?

When Will You Use SQLDiag Tool ?

MS SQL Getting List of All Column Names of a Table