Forum Discussion

svrmadurai's avatar
svrmadurai
Copper Contributor
Jul 25, 2022

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

  • JensNilsson's avatar
    JensNilsson
    Copper Contributor
    Jul 25, 2022

    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

  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Jul 25, 2022

    Hello svrmadurai , nowadays 70 GB is small in size, I have database with 700 GB and more.

    Backup is no issue as long as you have a good performing storage.

     

    Olaf

Resources