Back To Basics: Recovery Models

The recovery models tell the SQL Server how much transaction log data to keep within the transaction log, and how much data recovery there is.  SQL Server has three different recovery models which are SIMPLE, BULK_LOGGED and FULL. Simple Recovery Model Simple recovery model is the most basic recovery model and it provides the least […]