You Don’t Need Log Backups

You don’t need log backups. You don’t. They aren’t required for SQL Server to function.

The place when you don’t need log backups is when you have a database operating in the Simple recovery model. In this model, your transaction log will clear out on a regular basis, every few minutes, and the space will be reused.

I saw a post recently where someone said they had a database that only changed once a day. Data was loaded once a day and otherwise the database was read only. In that case, you:

  • Need log backups if you are in Full or Bulk-Logged recovery models
  • Do not need log backups if you are in simple mode.

It doesn’t matter how many changes you have, if you don’t have log backups in full recovery, you’ll eventually have an out of control log growth situation.

About way0utwest

Editor, SQLServerCentral
This entry was posted in Blog and tagged , , . Bookmark the permalink.