Skip to main content
Skip table of contents

Database backups

MSSQL

For database backup we recommend using the “Simple” recovery model as it is a tradeoff for between the size of log file with the possibility to restore to a specific time in case of a major breakdown of the database server. Normally, the database should be under 20GB long term. This will produce the log to be of size approx. 60GB depending on the frequency of making a full and partial database backups.

The recommended frequencies are:

  • Full backup: weekly

  • Partial backup: daily

The main issue with the “Full” model is the size of the transactional log (keeping every change in a log). This increases the database log file size significantly as it is keeping a enormous amount of data. If the space for this log is not an issue (it can grow over 100GB), the full mode can and is recommended.

To switch the model, please refer to the screen below (under the Properties option of the database):

image-20241112-095824.png

Relevant links: https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/back-up-and-restore-of-sql-server-databases?view=sql-server-ver16

Difference between recovery models: https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/recovery-models-sql-server?view=sql-server-ver16

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.

Contact Support Close