Introduction

This article gives an overview of the Mongo log cleanup, DB backups, and transaction logs cleanup activities.

Activities

Production Environment Backups

• Full DB - once a week
• Differential backup - every 3 hours
• Transactional logs - 5 min
• Delete backups - Every day (Retention 2 weeks )
• Mongo Log cleanup - 90 Days

Non-Production Environment

• Full DB - once a week
• Diff - every 3 hours
• Delete - Every day (Retention 1 week)
• Mongo Log cleanup - 90 Days
  
  

Additional Information

All the steps can be automated using SQL server jobs.