SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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.

The Voice of the DBA

Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest


Posted by Dukagjin Maloku on 26 August 2010

Yea, simple explanation, thanks, Steve!

Leave a Comment

Please register or log in to leave a comment.