Forum Discussion
SQL DB BACKUP PLAN
In our sql servers we have database size more than 70 GB how i can plan for daily sql DB. We have more than 20 servers like this. Kindly help on this and share how to take backup
Hi svrmadurai
I don't think 70GB sound super big of a database, but if you have a lot of them in the same server I can imagine that it takes to many hours to backup them all, and then you're pass your intended backup window.
If it's lite that, I would try this.
Try to make a Full backup every second day and a Differential backup every 6 or 12 hours, and the Transactional logs in between. How many depends on what SLA or how db intense the databases are.
My self preferer taking full backups every day, but it I can't I do like this
Kind regards
/Jens
