Transaction Log backup frequency

• toddj

  SSC Enthusiast

  Points: 156

  More actions

  July 9, 2004 at 9:19 am

  #86151

  Hi,

  Can anyone give me the low-down on how often to perform a transaction log backup. We are on the back-end of a major issue with we had in restoring data and I think much of my problem

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  July 9, 2004 at 9:43 am

  #514115

  It depends on how much data your business can afford to loss. We backup it every 15 minutes for business critical database.