SIMPLE recovery model in SQL Server

SIMPLE recovery model usage

What is the SIMPLE recovery model in SQL Server?

Simple Recovery Model is the basic recovery model available in SQL Server. You cannot back up to an exact given point of time using simple recovery, only till the last Full or Differential backup.

The Full Recovery mode, when managed properly, allows a database to be restored to a definite point in time.

By the way, this check is a part of our SQL Server Health Check service.

Should I use SIMPLE recovery model?

Simple Recovery Model is not ideal for situations where the user cannot afford to lose data.

Think about how much data loss you can afford to have. (It is simple to setup SQL backup in the way so you’d only lose 2 minutes max without any downsides.) This is called, Recovery Point Objective (RPO).

  1. Think about how much downtime you can afford to have in case of failure. That is the Recovery Time Objective (RTO).
  2. Both of those terms together add up to the Service Level Agreement (SLA).

Based on those, we can now design appropriate backups plans (fulls, differentials and transactional).

More information

Microsoft – Recovery Models (SQL Server)

Let our expert SQL Server Consulting team handle the technical complexities, so you can focus on driving your business forward with confidence.

Picture of Mark Varnas

Mark Varnas

Hey I'm Mark, one of the guys behind Red9. I make a living performance tuning SQL Servers and making them more stable. I channel my SQL into our SQL Managed Services, SQL Consulting and our internal database products.

Leave a Reply

Your email address will not be published. Required fields are marked *