Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Currently we have a number of databases that are in full recovery model. This is a conscious decision.

We also run the transaction log backups every 15 minutes.

But we run the transaction log backups only during the hour when people work with the databases, that is between 7 in the morning until 8 in the evening.

My question is:

  • On a technical level, is this a good practice or not?
share|improve this question
    
The frequency of transaction log backup depends upon the RPO and RTO agreed. What is your case ? – Shanky Jan 18 at 10:48

On a technical level: is this a good practice or not?

I would say not. If the database is experiencing no activity at all during the business off hours, then taking the backups is very low overhead. On the other hand, if the database is experiencing any activity during business off hours then not taking the backups is a serious problem.

My stance is that taking the backup has advantages:

  • is "future proof": if someone adds an off-hours job, your backups will 'just-work'
  • less complex, is easier to explain/understand/operate: no special hours for log backups. No special recovery procedure for 'off hours' vs. 'on hours'
  • it does no damage
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.